Tension is vital for any story. It’s what grips the reader, what keeps them hanging on from page to page and chapter to chapter. Tension can be intense who’s-going-to-die moments, or subtler ones that arouse curiosity.
It exists primarily for the reader. Your characters may bite their nails with worry, but if your reader shrugs and puts the book down, the story will stand still.