Most of us "Olde Pharts", that had a chance at a Military Acadamy education, and didn't take advantage of it, Regret that decision today.
Michael, you're showing some real smarts considering this path at this ppoint in your life.
The Acadamy of your choice, should it not be available, should not deter you. As mentioned, there are several to chose from, and suprizing, a few non=traditional ways of getting an appointment.
One way, often overlooked is through the Reserves
I have personal experience with the Navy Reserve programs, and I believe they may still be operating the same way. I imagine that the other branches offer similar programs.
Navy reserve had open billets to Annapolis. As a Reservist, you needed to apply through your unit, pass some physicals, and academic scoring and you were very likely to be selected. They also had a program called R.O.C. (Reserve Officer Candidate) where you attended the college of your choice, at your expense, and upon completion of the course, and graduation, you recieved your commission.
I mention this only to show you that there are lesser known ways to attend the nations military acadamies.
Knowing you I'm sure you'll get yopur appointment, and become a terific asset to your family, and country.
Best of luck.