I think his plan to become a professional athlete is a pipe dream and he should stay in school.
a fantastic but vain hope (from fantasies induced by the opium pipe); "I have this pipe dream about being emperor of the universe
A pipe dream is a hope or plan that you have which you know will never really happen. You could waste your whole life on a pipe-dream. A fantastic notion or vain hope