I am being very cautious around this one. Blizzard has changed leadership numerous times and the game has still proceeded the same. There's another thread floating around concurrent to this one claiming Microsoft is letting Blizzard operate largely independently, indicating that these changes aren't exactly coming from elsewhere.
People get hyped every expansion and then (almost always) end it disappointed, repeating the same cycle for the next one. Dragonflight seems to have been a change, but I'm going to be holding off until at least a few months into this one.
I also really don't like what WoW has become, with addons and meta-gaming largely driving people forward. Seeing things like Plunderstorm not allow addons gives me hope.
TL;DR: Things seem to be getting better, but for this salty early-WoW vet they aren't there yet. With all the changes in the world I'm not sure they can capture the same magic while still having addons in the game at the level they are currently. Things are looking up... but Blizzard still has a lot to prove to me to get me back.