I mean, there are plenty of stories to tell about everyday normal people who survive extraordinary odds. The Walking Dead was built on exactly that trope, and I would wager lots of stories in the True Crime, Horror, and Disaster genres all feature this kind of (protagonists? Heros? What word would you prefer here?)
I just think D&D has never really done those genres well. Arguably, the first three levels of OS D&D are survival horror, but the game never billed itself as such and it doesn't remain that way for very long. I think that's why so many players felt a tonal disconnect: they are promised The Avengers, but only if they sit through Halloween first.
For me, the "normal people who are thrown into an extraordinary circumstance" doesn't really mesh well with D&D, If you can make it work, more power to you, but it reminds me why Ravenloft games so often fail: D&D isn't good for real horror, but it's great for dark fantasy. You either play to the system's strength, twist the system to play the genre, or find a better suited system.