some thoughts
- generally, let the players know that its The Final Battle so they can choose heroic sacrifice
- the ideal adventure is written so that failiure is fun
- in the OPs example, it seems the problem is not so much that they failed, but the rubbish manner of their failiure. They...