That's another thing about galaxy ending threats... you KNOW our heroes will win. It kills any possibility of real drama because it's impossible for them to lose.
There's been a lot of interesting talk these past few pages. Mr
@Farscape One, I'm not aiming anything at you in particular, more talking about the general sentiment expressed above which has been echoed by a few posters.
Heroic drama is something that goes way back. Like way, way back, and one of the given things about such drama is that the audience fully
expects the hero to win.
We know Sherlock Holmes will solve the unsolvable case. We know that Doctor Who's Doctor will find a way out. We similarly know that the heroes in Star Trek will win through.
As we the audience are implicit in that, the drama therefore comes not from the fact that the heroes will win, but
how they will win. The story and drama are drawn from the fact that our heroes face the undefeatable and somehow defeat it.
I'm reminded of Series 6 of Doctor Who (Matt Smith's second) which was heavily promoted using the idea that this was going to be 'The Death of the Doctor'. I'm sure nobody actually believed that, any more than audiences believe in things like 'The Death of Superman!' or, as in Discovery 'The End Of The Universe As We Know It!'.
In such dramas, the beats of the story come from our heroes facing the insurmountable and prevailing.With Season 4 of Discovery, my reaction was not 'of course they will win', rather it was 'how will they win?'. That's where the meat of the drama is. Star Trek is a story of larger than life heroes, so it becomes a story of a process, not a result and I think in that sense it works for Discovery. Hence them having to spend a few episodes to even figure out what the threat even was.
The times that some kind of pyrrhic victory is the result are exceptions and all the more notable for it. At the end of the day though, generally speaking audiences like heroes to win. It's telling that the initial reaction to the original ending of The Wrath of Khan was overwhelmingly negative, to the point where new scenes had to be shot and reediting had to be done.
It does seem, judging by plot synopsis that have been revealed, that SNW will mark a move away from larger stories into smaller more personal ones. As you pointed out, it's really not possible to draw a comedic episode from either Discovery or Picard, but SNW has a comedy of errors on it's slate within the first five episodes.