Hussar
Legend
A couple of thoughts.If you're predisposed to that style of play, yes. If it's not a style of play you're interested in, no.
1. The obvious one is that no playstyle will ever work without player buy in. If your players are totally uninterested in a particular way of playing, there's nothing you can do about it. They will not like it and it won't work. I spent the last several years bashing that wall and it's frustrating. But, at the end of the day, you just have to accept that you have two choices - adapt your playstyle to the players or get new players who share your playstyle. It really is that simple.
2. It would probably be best to look at systems that don't really have character death to answer your question. I'm reading Ironsworn right now (and I REALLY want to give it a go) and I realize that death is on the table but is extremely rare. You'd pretty much have to deliberately decide that your character is going to die now for your character to die. Yet, it's absolutely chock a block with impactful choices and consequences. I highly recommend it and it's a free download. Ironsworn RPG - Downloads
Other systems follow this vein too. Older version of Doctor Who (I haven't seen the 5e version) made it so that it was virtually impossible to kill a PC. A number of the more pass the story stick, hippy dippy indie games follow this vein too. There's a hoard of these kinds of games out there to read.
It's an interesting question, and, frankly, it's a perennial one because the lethality level of a game does strongly impact virtually everything about how the game is played.