It's just a style/story preference one way or another. Books are trying to accomplish different things, some are wish fulfillment, some explore loss, and all sorts of things in between.

I do get taken out of the story when I know that the characters are all going to be fine in the end, but I also know lots of people want that and it can be a nice escape from a world where that is definitely not the case.