First off, I wanted to thank Kristen (even if I'm a little late... I step away for a few hours and several pages of posts show up!) for taking the time to come here and talk about this. Putting aside the fact that this conflict over the "wrongness" of Janeway's death is the reason you did so, it is fascinating for me as an aspiring writer to be able to read your insights into the whole process that goes into creating these books, and I appreciate it.
Now, to touch on something from a couple pages back...
^^
Honestly, I do find it hard to believe that they love the characters when they kill them off. It doesn't make sense.
If that doesn't make sense to you, then you have a lack of understanding of something that is a very important part of being a writer (well, assuming you're writing in a genre/setting that puts your characters in a certain degree of peril... this doesn't apply if you're writing, say, a romantic comedy story). Writing the death of a character you love can be very difficult, certainly, but sometimes that death is... maybe not quite "necessary", exactly, but it's simply what's been chosen by the author/editors/whoever as the most compelling story path to take.
But as I said, it isn't easy. One story I've been working on a lot lately - a huge sci-fi story, with a large-scale conflict spanning multiple years - certainly has its share of death, including a few very main characters (I'm talking characters that - were my story a Trek TV show - would show up in the theme song credits every week). There was one scene I just finished writing up last week, involving a main character death, and you know what? Writing it kinda sucked, in a way. It was painful. I found that as I was writing, suddenly I didn't
want to do it... I didn't want her to die. But that was the story I had created. Her death was an integral part of the character development of another of my mains, and the resulting scene is compelling, gut-wrenching, and emotionally gripping. Well, at least I
hope it is... the assumption there is that I've written it well.
Clearly, you are not a fan of main character death in general (understatement is my friend

). That's fine. I personally don't have a problem with it, when it's done well. But my point with all this is to try and get across that 1) it's not
objectively a bad decision just because some people don't like it, and 2) it is entirely possible to love a character that you end up killing off. In fact, for some writers (for me, certainly, though not
all writers, from what I've read/heard), it's an absolute necessity, unless NO ONE is going to die, since if I
don't love my characters to a certain degree, I'm not going to be writing them very effectively.