I have a 16-year-old son. I’m in my early 30s (had him very young) and a professional footballer. My son also dreams of becoming a successful footballer (he’s been playing since he was 6), but he’s just… not great. He’s good, but not great - and in this extremely competitive industry you need to be at least great in order to even stand a chance. So I told him, as someone who’s been doing this for a very, very long time & is active in this sphere, that he should find another, more attainable dream. He took it as me not believing in him, but I’m just objective and realistic.
Perhaps not necessarily wrong, but people sometimes don’t like hearing the truth. I don’t agree with the other comments that you should support him - to me, that sounds like bad parenting to not at minimum set up a backup plan when things start to fall apart.
My take on this situation is that you may have to tell him in a more subtle manner. Fortunately, professional athletes are known for being notoriously competitive, where even talented people can lose out on an opportunity simply out of bad luck. This could give you a way to voice your concerns in a way that doesn’t directly imply that he’s not cut out for the job, ie “you still need to be very lucky to go pro. I was very fortunate, but we shouldn’t be counting on luck for your living. You can still try for it, but I really think you should also have some backup options if things don’t work out”