He can get 'free' flying exposure (and perhaps a few lessons) through the CAP, so that's a good place to start, and if his high school has an ROTC program, there's more free flying there. Take him back to Sky Blue U (the Air Force Academy) this fall, about a month after the start (ie. October) and get him a tour, that may light a spark in him...or not.
As far as, is it going to be a good career for him? Well, on the military side of the career, perhaps. If he deciedes he wants to fly in the miltary, that will be free flying lessons and a pretty stable career, compared to trying to build time in the RJ world.
But...he's only 13 now, 5 years from now he'll be 18, and the comercial industry will have changed by then, ie. it will be better, or worse, than it is today, but it won't be the same. One thing in his favor, in the next 10-20 years (when he's 23-33) the Majors will be losing thousands of pilots, hired in the 1985-1995 eara, who will -age out- and be retiring, so there should be some demand for new pilots...maybe...if;
Cabotage doesn't become the law in the US,
And if the mandatory retirement age doesn't get lifted to...?
And if any of today's Majors are still in business, etc.
Nobody has a crystal ball, nobody knows what the future holds in this industry for next year, let alone 10-30 years from now (your son's time frame) but getting free flying lessons via the ROTC and a free education via the AFA is never a bad thing, and he can fly in the Air Force or even the Navy (not that there's anything wrong with that) for a full 20+ year career, and still be young enough to get out and then get hired on at a US Major, if they still exist 30 years from now.
Oh, I almost forgot, the Air Force now has drone flying training program, so your kid could fly drones over Pakistan, from a trailer in Las Vegas.