I totally get where you are coming from. My son received his TWE from USNA last year the Friday before I-Day,
That is awesome that your son is attending college with an AROTC scholarship. My mom heart hurts for you and your son for the TWE. Don't allow your son or yourself to think he wasn't good enough. Awesome candidates get turned down from the academies every year and it has nothing to do with not being good enough. He either wasn't what they were looking for or they didn't have a spot for him.
My personal opinion (which I know doesn't count for anything) is that one of the reasons this whole process is so frustrating is because only parts of it are objective (test scores, gpa, cfa, etc.). The subjective parts make it so challenging because those are the parts less talked about, less comparable, seem to change from year to year, encompassed by the whole person concept or the whole candidate score, demographics, diversity, and whatever else they throw into the mix that is not shared and we have no control over.
Your son is on an excellent path with his scholarship and doing well in college. He is going to be a success whether he continues his current path, decides to give West Point another chance, or goes for something else. You must be so proud of him. He has already proven he has what it takes.
Even knowing God has a plan but not knowing God's plan and how it aligns with your plans doesn't make a TWE suck any less.
Best of luck to your son!