I'm a D&D Veteran having played since 1981 or so.
As I can only speak for myself: not so much, no.
I much, much, MUCH prefer other forms of failure: captured, loss of treasure, loss of loved one, loss of reputation, to death. When/if my character dies, I just generate another one and the game...