I've often wondered this myself. I've always liked Janeway, but she has characteristics that aren't particularly likeable.
You're looking at it backwards. For me, at least, it's not giving up a series that I love because Janeway is dead. It's waving goodbye to a series that I used to love, but which has finally managed to grind out the last remaining aspect I had an interest in.
Yes, I suppose I could say "Thank fuck, I don't have to pay attention to Trek anymore" and move on, but that's easier said than done. It was such a big part of my life for so long... my mother watched the original series when she was young (despite my Catholic Nana, who thought Spock looked like Satan

) and she introduced it to me and my sister when we were kids. We grew up watching all the series - Friday nights, when Trek was on, was family night, we all watched it. With bated breath, no less.
Then came Voyager. As a young woman who wanted to be a scientist, I was beyond thrilled to see a woman as captain. My uni had a SF club where we watched new Voyager episodes - and even the young men who told me that no woman could
ever be a starship captain watched. Because of that I was far more invested in Voyager than any other Trek series... but not so invested that I couldn't recognise that it wasn't very good in parts. Over seven years, the show that I loved most began, through poor story decisions, to scupper my love of Trek. I was forced to realise that there was a creative world outside of Trek that was much, much better. But I stayed for Janeway, because she was the only thing in Trek that could reignite that same excitement that I had felt at the beginning of Voyager.
Her asexuality, for instance. Fans moan that they want Janeway to star in Trek Romance novels, yet she was the single most asexual captain ever presented onscreen. Even stuffy old Picard got more than she did, and that's saying a lot. How people can identify with Janeway as a romantic lead baffles the mind, unless said people are as much without sex in their lives as sad poor Kathryn was.
It's because she was so asexual that I want to see it remedied. I'm loath to bring up the sexism charge again, but of all the Trek tv captains, the only one who is for all intents and purposes asexual (I refuse to count that stupid hologram) is the woman. It got worse as the series went on, silk nightgowns giving way to granny-wear, until finally it culminated in her love interest swanning off with Barbie of Borg.
(You can have a successful career, girls, but be damn sure if you do that no man will ever want you. Enjoy your life alone.)
That's why so many women Trek fans I know had such hope for the Voyager relaunch - that it would undo that horrible message, and give her the chance for a life outside work. Instead, she was as alone as ever, dying - essentially still alone - violated to death while the greatest power in the Trek universe looked on and laughed. I haven't seen those Trek fans that told me no woman could ever be a starship captain in years, but I suspect they're laughing too.
Yeah, you can tell me that other women in Trek get to be happy. But the one aspect of Trek that gave
me hope is gone. And her death, like her life, was
horrible.