John - I'm somewhat of the poster child for Dean's last comment. I graduated out of HS in the top 15% of my class of ~400. Thought I knew stuff. Applied to RIT, Syracuse, Pitt, and Cincy for engineering. Accepted to RIT. Boy, did reality hit - hard. I couldn't study my way out of a paper bag with both ends open. Darn near flunked out. Made a deal with school if I went JUCO route (ECC) they would let me back in - on probation. Learned how to study and darn near aced ECC while working and being an unpaid asst coach for 2 sports at old HS.
Went back to RIT and struggled again. Realized that I did not have the aptitude for theory - practical was my game. Finished with Mech Eng Tech degree. Signed on at TI making more than my old man. 20+ yrs, 2 layoffs, 4 employers , and 2 moves later I am in a good place.
Point here is just because this particular door closes not all are. Many are still open. Look at the options at D2 or D3. I hear / talk to more people that played sports at that level and are still tight with their teammates than at the D1 level and are very successful at what they do.
I appreciate your disappointment, but don't be. Encourage him, kick him in the butt when he needs it. In the end, it is your son that will set the direction for his life. You and your wife can only set the foundation.