For what it's worth, I personally deeply regret my career choice.
If your son has any creative spirit in him, any ambition, any curiosity, I would not recommend it. I find the job boring, tiring, overrated by the public and underrated by management. Out of a 12 hr flight I enjoy maybe the last 5 minutes, and only on the rare occasion I am not completely knackered.
Forget all the romantic stereotypes, there is zero adventure in this job left. All fun aspects have gone, life as an airline pilot is a constant struggle of fatigue, base changes, bankrupt employers and cost saving. The pay is going downhill since decades, and this will only accelerate further with more automation.
Pilots are the Uber driver of tomorrow.