There are more better ways to make a player fear for their character other than death.

Like killing a beloved NPC, making the situation much worse, taking away their valuables, making their god angry, being hunted by assassins, making them wanted across the kingdom.

Death isn't the only punishment a GM/DM has at their disposal.