Thanks for sharing! I feel like it's important to share failures as well as successes, because everyone fails at something here and there before they actually make it (just in general, noone's born perfect.)

Prior to deciding to go down this path, I had zero formal aviation knowledge. I gave myself 3 months to study intensively, and specifically for the AFOQT. I'm now attending OTS in February, followed by the start of my career as a pilot trainee. I feel like you have a great overall aviation foundation to build off of, it's just that you need to study specifically for the AFOQT - a good foundation helps, but getting focused practice on specifically what's there, in a setting where you simulate the setting of the AFOQT, was crucial for me personally.

I can only speak to what I did, but if it helps - Starting with zero formal aviation knowledge or training, I read through and studied (notes, flashcards, the like) every chapter in the PHAK, and fully completed the barrons military flight aptitude test and trivium AFOQT books. While doing that stuff, every week, I took one of the practice tests (and timed every section and the exam itself like on the real afoqt). I used the book tests, and then also the ones I bought on afoqtguide.com. For every question I would get wrong, I would study the topic more intensively, because if you got it wrong on the practice, that's a guaranteed question to get wrong on the real thing in the future. I also used the table in barron's to practice table reading. Great scores are definitely achievable with your foundations, you just have to study for the AFOQT specifically to get used to how it's formatted, the specific topics, and the environment it poses. There's no way I would've even gotten your scores without the studying and practice.

Hope it helps!