The stakes in don't have to be apocalyptic to be meaningful.
They just have to be important to the characters involved, meaning the characters (especially on the protagonist side) need to care about the outcome, and this caring is often about context.
For example, how dramatic is cleaning a kitchen? Ordinarily, not at all.
But if the character cleaning is homeless, desperately needs money, and won't get any paid unless they clean this fancy, extravagant kitchen perfectly before the owner returns home...
In that context, cleaning a kitchen can be riveting.
So big conflicts are fun, but not all stories have to have big conflicts with world-ending stakes. We will care if the characters care, based on our ability to empathise.
(In the lesson on Evoking emotion in the reader, we go into more detail about how stories rely on empathy.)