We take cubs and scouts flying and never have a problem bit older then your kids but most seem to enjoy it.
I guess its important to tell your child that if they are scared and dont like it to tell you and then you just return to the airfield although I am sure they will love it and will keep asking after when they are flying next!
TW