I disagree. Not every narrative has to be one over some apocalyptic threat. I actually prefer the more grounded (for fantasy I suppose) story over the zombie apocalypse-adjacent White Walker stuff.
If I want to watch a history lesson, I can do that, there are some great documentaries out there. Probably produced for less money. And I would actually learn something.
But of course, there are many interesting narratives that don't involve the apocalypse. The Wire has a great one. Bladerunner is superb. The recent Black Bird was captivating, too.