You should support your kid, even if you’re not convinced of his chances of making it. Anything else is just going to permanently damage your relationship. The best you can do is make sure he has a plan B. If he’s good in school he’s well on his way to that, so not much to worry about.