I have a feeling that, now that we're actually seeing Pike's missions on Discovery, they are very much NOT family friendly. We have Spock accused of brutally murdering doctors and going insane, human experimentation via spore drive through Stamets, and most other things are classified. Even the only canon mission we knew of that Pike took, before Discovery, was far from family friendly: he was abducted by aliens to be used as a breeding slave. That's as "not safe for work/kids" as you can get. Remember what Captain Harriman said to Kirk in Star Trek Generations: "I remember reading about your missions when I was in grade school." Kirk's "historicity", as mentioned in Voyager, may have less to do with actual historical value and more about Federation marketing, especially now that we know there were tons of five year missions. Kirk's missions were (relatively) family friendly for kids. TOS was considered a kid's show in Germany (thus the redub of Amok Time over there to remove all mention of Spock's "urges"). Kirk's missions were good recruitment material for kids who dreamed of being Starfleet officers. If Federation children asked what Starfleet officers do, they could point to Kirk and talk about his missions. You couldn't do the same for Pike's/Discovery's missions.