There are some (like "10 Candles") that start with that premise, I feel that this is broadly incorrect. Horror can end in a TPK, but it isn't "supposed to".
Before you ask about how you do this successfully, you probably want to ask why you would want to do this. Because that why should...