to be candid, I've had some dissonance / a bit of a tug of war internally on whether to engage on this thread, as you'll be competing with our son for one of these coveted slots, and yet after sleeping in it, ultimately we unwaveringly want the best to serve shoulder to shoulder with him and others no matter where in the Navy each of you serves, so with the bigger picture in mind, I'll try to add a couple of details here that you may find useful.
My understanding is that you can take the ASTB up to three times, and that your last score is the one that is kept. Sounds like you took it twice, and have a 6-4-6 score. Sounds like you have one more shot to take this if you want it, and your last score will count only wither you stick with the 6-4-6 or your third try. .
talk with your chain of command/ others who just went through this on whether you are competitive for aviation between the tier of your major, your GPA, your evals, your uncorrected as now sits vision, no DQing color blindness etc. Get an idea of where you stand. A factor you can't control is how many SNA/ NFO selections the navy needs this year.
Recommend you get additional study materials and take mock tests online to confirm you consistently can score higher, and retake it once you can. Make sure by trying to improve you don't knock yourself out of contention for SNFO by lowering your score. Does your university allow you to use the sim for this test at their facility? If so can you plan a couple of days on campus and reserve that sim to get more comfortable with the stick activities? Can anyone mentor you on how to excel? recommend actual acclimation vs substitutes for yoke work, where possible.
Keep your timing in mind - are you commissioning in May of 2023? What is the deadline up to update your packet/ scores/ retake this test? Make sure this will count.
Confirm which scores count for which roles you are pursuing? The ASTB-E has four composite scores: the Officer Aptitude Rating (OAR), the Academic Qualifications Rating (AQR), the Pilot Flight Aptitude Rating (PFAR), and the Flight Officer Aptitude Rating (FOFAR). The OAR is scored from 20 through 80 using one point increments with average scores ranging between 40 and 60.
Student Naval Aviator = AQR + PFAR Scores
Student Naval Flight Officer = AQR + FOFAR Scores
My DS too has a dream to serve in an aviation role - I appreciate the passion you folks have for this. honestly I don't think you'll regret going for it with the preparation in the weeks ahead and before any deadline - I do think you'd regret not going for it by at-least studying and seeing if you can improve mock scores if it doesn't work out. To my understanding, there are many less SNFO slots than SNA slots, in the Navy - so make sure you put your best application forward.
Good luck and hope any parts of the above may help.