If you are staying multiple weeks, you may want to do North first as August is the hottest (you may get a 35+°C heat wave even in Paris), and go South then, as September should get less hot and less busy with roasted Northern tourists after school restarted. The Loire castles which are about 1/3 from the North could be spectacular for kids, you can go down the Loire river by bike over multiple days.