I'm not too thrilled with it either, but I think it's silly to rule out any storyline just because it takes a risk you don't like. Sometimes people die when you would rather they didn't. Exploring that is a valid literary option. I wasn't happy when Star Wars killed Chewbacca either, but the line continued and there were some good stories as a result.
My biggest complaint wasn't with the decision to kill Janeway, it was with the manner in which it was done. It just didn't work very well. At least Chewy got to go out with dignity.