We went on SR over Labor Day week, as a party of 2 adults who shared a cockpit with a party of 4 - super keen mom and dad, very elderly gramps who didn’t seem to know SW at all, and a very upset and angry 4yo boy.
Mom & dad got the pilot spots, gramps and kiddo were gunners, DH and I got stuck as engineers. Kiddo screamed the whole time, angry that he had to sit alone and be strapped in, yelling “I don’t want to do this” the whole time. Gramps didn’t realize he needed to push buttons, so just watched the screen. Mom and dad focussed only on the ride, and not at all on the screaming/confused members of their party, but even with their concentration they crashed a lot. The CM unloading us joked that it wasn’t the worst flight he’d seen, but it was close. It wasn‘t the best ride that time, but luckily we had a chance to do it again later in the trip.
So yeah, OP, the size of your group makes all the difference in the world. if your party is six people, and you’ll fill up a whole cockpit, go for it. Your child’s ability and/or willingness to participate won’t impact anyone other than your group.