Unfortunately (or fortunately, depending on your outlook), life isn't that predictable or deterministic. Life experiences, learning and age changes not only perspective but also who you are.
Try to future proof by picking multiple majors or selecting "the" school to attend can prove to be foolish most often. The student will find his/her own path regardless of all the planning. It may mean that you transfer out of Ivy/Ivy-like to UC or from northern to southern state, being close to home. Or change majors multiple times. It ultimately depends on what fits the student the most, and the likelihood of attaining success.
So what if they stop playing soccer. The end will come one day - regardless of when stopping. It may be after college or simply while in college. At some point, other than just a very small handful, will not be professional athlete and have to transition to a working career.
Just have to trust your kid and support them so that they know its okay to flounder a bit and be lost from time to time. Its all part of growing up and finding out who they really are. As for still playing in college, one has to really love the game and continue to evolve. Its just that simple.