One of the great things about the Young Eagle / Sporty's ground school is it is the same ground school they offer to all potential pilots, it qualifies you to take the FAA written test (instead of needing an instructor's endorsement), and they track the Young Eagle's process through the course so that when he/she completes the first half, EAA automatically sends out a certificate for a free 1 hour flying lesson at the school of your choice (EAA pays the flight school for that lesson).
The course does not have to be taken right away. If your son is younger (let's say 8 for example), he can wait until he is older to take the course. After all, if he takes the FAA written test and passes it, it is only good for 2 years before it has to be retaken, so it's better to wait until he is within 2 years of getting his license before taking the test (must be 17 years old to get a license). They keep a record of the kids, so it he will be able to safely wait and take it later.