Supposedly, we read stories "to find out what happens" – but in most stories, especially genre stories, we actually know the ending. Anne Boleyn gets her head cut off. The romance ends with the couple together. The good side wins in fantasy. Yes, people play within and against a genre – "grey" characters in fantasy don't split into good-vs-evil - but still, the central rules hold. What if Mrs Coulter had "won" in His Dark Materials, Lyra's quest failed and Lyra dead? Or if Katniss was killed in The Hunger Games?
We know that's not going to happen. So why do we keep reading? Why do we care? Why does it matter?
Part of the reason is that the reader and author have a secret contract: the reader pretends not to know the ending, in return for the ending they were promised; the author will deliver the promised ending, and "hide" it from them for most of the book. The secret to that is plot-layering: the plot is rich enough to distract the reader from the ending. (That's where many genre romances fail, incidentally: the plot's too thin to hold the happy ending at bay and there's only so long that two rational human beings can sustain a misunderstanding.)
Often, in layering the plot, writers pull back from "big events" – they're "too melodramatic", "too unrealistic" - but in real life, people do die. (Everyone dies. Eventually. As George RR Martin is so intent on reminding us.) Friends do turn against each other. Shocking revelations do come to light, whether through the old trope of the box in the attic or the newer style of seeing inside someone's computer, or phone. The "unrealistic" / "melodramatic" defence is often a cover for being nervous of the big stuff, the good as well as the bad. But the story needs its chiaroscuro: its moments of bright light and deep dark.
That said, one can easily go too far: "A really BIG problem is one that affects THE WHOLE WORLD! There's a nuclear bomb in Rome!" Fine if you're writing action thrillers, perhaps, but you don't always need to make the problem bigger: sometimes you just need to zoom in closer and make it matter more. What's more, throughout this quest for obstacles and plot-layers, we often forget the ordinary stuff. We give our characters one giant problem to solve (Ebola outbreak! Raiders on the coast! The man you love is dying!) and make everything else in their lives trouble-free. Their fairy godmother takes care of everything else, from their clothes to their home to the reliability and health of everyone around them.
Restoring normal, practical domestic / relational / financial / etc problems does two powerful things. First, it's a great source of material. It's not a distraction from your plot: make it part of your plot. Second, it's verisimilitude in a bottle: it grounds the story to make it convincing, realistic; it adds that grainy texture of real life that makes us believe even more strongly in the character and hence care even more about their story.
Ultimately, what matters in the story is what matters to the character. And the more we know the character, the more we care about what matters to them.
If you'd like to learn more about the principles of all the elements of storytelling, and create stories that matter as much to the reader as they do to you, the Story Elements course explores the 12 key elements of stories through hands-on activities and real writing processes, in lively workshop-style classes.