A couple of comments. First, I can tell you that the trend in the US is away from undergraduate education towards graduate education. Perhaps as someone international you might think that an undergraduate degree from a prestigious university is the end game. Right or wrong, in the US, it is graduate school. I can also say with confidence, that D-1 athlete coming from any university is going to garner serious consideration from most if not all graduate programs including those top tier programs that ultimately lead to the financial success that you allude to. The same traits that created success in the gym are the ones that these programs are looking for (yes, scholarly aptitude is required, but all things equal). In this paradigm, it might make a smarter move to get a "free" undergraduate education saving for the expensive graduate school.
Second, while we always want the best for our children, and have much more experience to share with them, we can't live their lives for them. In spite of all our advice, they sometimes choose their own path. I am sure some might strongly push their child to a particular school, and that is their choice as a parent. I think when most of us come down to it, we are not going to force our children to go somewhere they do not want to go, especially if they are fortunate enough to achieve that accomplishment after so much sacrifice and hard work.
Bottom line, as many have said, there are many different roads to success. The results that you are mentioning from going to a stronger academic school only really apply to graduate programs with the exception of perhaps a few Ivies (Harvard, Yale, Princeton).