I don't think anyone should die and I think a "down note" isn't art or good writing. Trek isn't about reality, it's about hope for a bright future. It's like Paul Potts and now Susan Boyle on "Britain Has Talent", Trek has far more in common with "Slumdog Millionaire" than the "dark" or "real" fiction or movies that some people like.
There isn't a thing wrong with liking it dark but you should remember that there are a lot of people that don't. Trek should be Trek, not an imitation of BSG or Babylon 5. Trek isn't about dying, it's about living.
Kirk was right when he changed the parameters of the Kobayashi Maru test. I think people miss the whole point when they quote "It's how we face death." It takes a second quote from "Search for Spock" to actually get the whole idea.
"My God, Bones... what have I done?"
"What you had to do, what you always do. Turn death into a fighting chance to live"
Trek isn't just the illusion of happily ever after for the Trek characters, it's the illusion of HEA for us all.
Brit