Why do we find comfort in terrifying stories?
bbc.com
bbc.com
The bigger and more terrifying the monster that gets beaten in the story, the more comforting it is. This is true even if the "monster" is a situation rather than a being, and even if it is merely "lived through" well, rather than "beaten".
If you drive a 2006 Honda Civic to work (really safe, good mileage, and it's completely paid off!), spend all day writing Java code that someone else scoped, spec'd, and paid for, then drive home to your family and have spaghetti for dinner (we have spaghetti every Thursday, it's our tradition!), of course reading a story about the zombie apocalypse is going to appeal to you. It satisfies a biological need you're not currently fulfilling: to be put in danger and successfully navigate your way out.
It's the same reason people holler at movies/shows telling the characters not to go in that dark room, or yell at the NFL game that the quarterback should have thrown the ball earlier. It's the same reason people play Sim City or The Sims or Football Manager/OOTP/Motorsport Manager or any other "god games". It gives you a feeling of risk, reward, and power you're not likely to find in your real life.
This has been a thing since at least Homer's Odyssey, created in a time where the average person took on a level of risk we'd never even consider. And this thrilling tale of dashing heroes sacrificing their lives to get back home to their boring life only to find out they have to fight and kill even more to protect their boring home life... it's not a new trope.
Or maybe our lives are not as boring and risk-free as we would like to think and our collective unconciouses draw us to these stories in order to process the dangers our egos pefer to avoid.
I mean, even if no external danger existed, there are the perennial existential dangers of living a meaningless and empty life. Zombies come up a lot as the symbol of mindless mass action, looking for brains (wisdom?) in life. I don’t want this to come across as criticism of the lifestyle you painted but merely as a thought experiment to entertain; when you drive a safe car everyday between home and work, and write code for purposes that other people scoped out for you, and you know there are many others doing the same, maybe there is already a bit of zombie action going on to begin with and that is why the zombie flick is interesting?
Which is not to say these are the only dangers. I mean right now we are in the middle of a pandemic, which doesn’t get much more biblical than that. I believe those terrifying stories has helped us do serious information processing and in turn created an adaptive evolutionary advantage in preparing for these eventualities.
About actual terror and horror Thomas Ligotti makes some interesting points about this and principally views it as a way of dealing with the actual horror of life which is all too real.