No you are not right, you want something that isn't Trek to a lot of people. I don't like your interpretation. I want the illusion of Happily Ever After, and I am not alone in that. I don't want the current writers' interpretation of "rough waters". It isn't art and it's lazy writing. I don't want dead anyone period. You can have conflict without killing someone.
The thing is I know I'm not alone, just recently the "New York Times" ran an article that states, "In a recession, what people want is a happy ending."
Yup, I got back into trek partly because real life was pretty pants a while back, and you're always guaranteed a happy ending in Roddenberry's universe, right? I'm not old enough to have been there for the hoo hah when they killed Spock then changed their minds and brought him back, I didn't realise that hadn't been the plan all along until I started reading here. By the time I got into Trek the first time around we were safely into TNG territory, yes Tasha was dead but she was fairly minor in my estimation (and it seemed like she kept coming back), then DS9 killed Jadzia but not really because there was always Ezri. So I got back into this nice safe world a couple of years ago, or so I thought. Even Nemesis which fell during the spell I was out of watching trek didn't really kill Data properly because there's the scene right at the end where B-4 starts singing and so you realise he has his memories, though I reckon by then TPTB were experiementing with a much darker side of trek.
So I agree with Brit, I don't like the way TPTB are taking my favourite fiction right now. Real life sucks, I'm fully aware happy endings aren't reality but I don't want the stuff I watch as escapism to be anything like reality! I know plenty would disagree, sadly for me including most of the current people in control of where 'official' trek is headed. I'm just glad I have the earlier episodes and fan fiction.
Dragging this back to the topic of Endgame.... I think them not getting back is a terrible idea. the whole point was that all along we knew they'd get back at the end. I think Endgame sucked and the way they got back was a huge cheat, but the idea of them not getting back is worse. I just wish they'd done it differently.