Your story will follow your Protagonist, your main character, on their journey to try and get something they want or need in their lives. The stakes of your story are how much your character will suffer if they fail. The higher the stakes, the tenser and more dramatic your story will be.
The resurrection of characters that have died can be a dramatic game changer that enhances your story, however, if used too easily and without careful construction, it can have the opposite effect. Your audience can be left feeling like all the tension has been sapped away because if characters die it doesn’t really mean anything.
If you’re writing a book or script where there is risk or peril, and you want your audience to believe in it and feel tense during scenes with fights or danger, you need to be willing to kill your main characters. But killing them needs to be done in a way that actually causes the sense of tension you need your audience to feel.
If you are writing a scary story, or a thriller or a mystery, suspense is one of the key things you need to make your story appealing to your audience. It will keep them excited and intrigued so they will want to stay with you and keep watching or reading to the end.