How do you go on from a player death? Is there in general some trick to balancing the need for risk-taking to be punishing without destroying the fun?

I get bit by a werewolf and sentenced for execution due to being a danger to society. For some reason they choose death by drowning and it turns out I cannot drown because I am a vampire. I then actually do not die because I am an undead.