Star Trek: Picard had a slow-paced story, was intended to be a miniseries, and while it ends on a space battle and the fate of the universe at play (and begins with some phaser-fighting), it is mostly a thriller filled with intrigue and not all-out action most of the time. The crew is the smallest in Star Trek history and its main character is literally a nonagenarian (played by an octogenarian).
I can't think of any Star Trek more fitting for us old people than Star Trek: Picard.
And I love Picard. I think it has the benefit of starting a beloved character from a very successful era, as well. I still think it suggests a bit from modern pew pew shooty video game action syndrome.
People mention BOBW and YE as examples of episodes that price people want action. That only proves to me that people want action with weight. When your main characters are all double clutching two phasers, gangster style, in an anti-grav scenario, anticipating an imminent warp corp breach....in what ends up being someone's dream ...it ceases to have the same effect.
Strange New Worlds is the least risky or challenging of all the new Star Trek shows. Don't get me wrong, it's a great idea, but it's literally taking Star Trek in a paint-by-numbers routine: "A Captain of a starship goes on adventures in space." This describes almost all of the six original shows (DS9 after the Defiant came into play), but none of the modern Star Trek shows.
I said SNW would be the closest. And you just laid out why it would be risky. It's not re-inventing the wheel as far as concepts go.
Honestly, if they asked me, I would do something completely off the wall. A mini about the last mission of the Enterprise B. Cuz why not.