Originally Posted by Mr Smiley
You usually reload and try again. It does not actually end the game, since you keep playing.
Failure in a game usually means that you try again, one way or another. A game where failure does not equal death actually allows for more interesting consequences within the narrative of the game.