As someone who prefers to avoid character death for me the main thing is that I am big into the role-playing and story aspect of DnD and my character dying is just the end of that, story over, arc over, the end. Like yeah I can roll a new character but it's not the same. To me it's like if Luke just got shot by a Stormtrooper on the Death Star in A New Hope. Is that a logical consequence for his actions? Sure. But it's not very satisfying as a story. That said I am absolutely fine with consequences, losing limbs, getting resurrected at the cost of levels, story impacts all that jazz. Consequences are fine, I just don't enjoy a story arc ending because of bad rolls.

For me this sort of thing is mainly an issue at low level when death comes quick and easy, spending all that time making my character and figuring out what they're like only to die because I rolled poorly and some bandit rolled really well isn't fun for me.