Years ago, I balked at WoW focusing on evils that threatened the universe (and then reality itself) because the fans become numb to anything less. You can't easily just walk that back to small stuff. Dragonflight may be being placed in that situation. You really cannot go straight from Zovaal to some evil dragon or a local threat on Azeroth. The main timeline has to stay at universe-level threats. However, we really don't know the villain of the Dragonflight xpac.
What I SPECIFICALLY said was that they HAD an opportunity to fix it correctly.
They created a NEW timeline with WoW Classic. If instead of making BC classic (and REALLY DO NOT MAKE Wrath classic), they branched off 1.0 with xpacs telling smaller stories, THAT could work. The fans would be much more accepting of smaller threats specifically placed THERE because you could sell it as untold stories between the end of 1.0 and the start of 2.0. The problem is, once you create BC classic, you have shut the door on doing that. You could go back and make Classic+ today, but fans wont accept it as much because you are jumping back and forth in a second timeline which makes it confusing and jarring and not everyone will understand what is happening.
I think they had ONE shot to fix the lore, and it was before BC Classic was released. Now they've blown past the window and both retail and classic are rapidly reaching world ending and universe ending threats.
Further damage can be done with Dragonflight because Dragon Isles was an untold story that would fit nicely in a Classic+ xpac. But they are now permanently unveiling it in the retail timeline, so it cant be used in a Classic+ xpac, which can be the wrong place to do it if they do it incorrectly. So Dragonflight could break WoW even more.
What Blizzard needs is a FULL reboot, back to 1.0, retell the story again but keep it local. Unfortunately, even that idea is now damaged because they have TWO timelines running. It would probably be best to end both other timelines and restart the lore with a modern game engine.