That wholly depends on the attitude of your group. A few of the best campaigns I've ever played in have ended in a TPK. As long as I didn't do anything stupid, I'm fine with that.
I, personally, would NEVER want a do-over. I had my shot, I blew it. But just because I take it seriously, doesn't...