Character-death is a tricky topic.
I'm opposed to having characters die just for shock-value or cheap tragedy. A character-death does not make a story inherently more ~*meaningful *~(or more "gritty and realistic") than it would be without it, and I dislike the use of a character's death JUST for the purpose of making me as a reader cry. As in, their death is ONLY there so that I as a reader can be sad about it.
The same goes for using stuff like the Girlfriend in the Refridgerator trope - when a character is created and exists long enough for us to know who they are, and then they're unceremoniously killed off so that the hero can have some tragedy to motivate his fight with the villain. It's cheap, and it's boring, and it frankly makes me roll my eyes a lot of the time. I've seen it before, and it isn't often that it's actually used for something creative and/or interesting.
That said, I'm not opposed to characters dying. I approve of it wholeheartedly! If the characters are doing something or are in a situation that carries the threat of mortal danger in some way, then there should be the possibility of them dying, and if they do die, that's okay with me! And I want to be really sad when it happens, because I want to care about these characters!
I just want their death to have a point. I want it to accomplish something beyond make me as the reader sad that the character is dead.
Does it impact the story in some way (other than the refridgerator trope mentioned above)? Were they supposed to carry an important message to someone, but died before they could get there? Did they go out in a blaze of glory while they fought to save someone? Did their death happen because they slipped up and weren't cautious enough around something dangerous? Etc., etc.
Has their character arc built towards it, and does it make sense of their character to die at that point? I'm a big fan of inevitable doom-scenarios - ones where it slowly becomes apparent that no matter what the character does, their arc is building towards their death, and the readers/character are aware of it. That way, the character's actions before their death become more important. Will they have time to do what they set out to do?
Honestly, though, it doesn't matter so much how a creator came up with killing off a character. If their reasoning was "yeah, this would make people cry!" that's okay, as long as they make that death work within the narrative.
I have a character I have yet to introduce in my comic, and I haven't decided if they're going to die yet or not. The story would work either way, but their narrative arc might work better if it ends in death. Or maybe it won't! I'm going to have to sit down and think hard about it, because I want their death - if they do die - to make sense within the story; both the main story, and their own arc.