Forced to agree.
I'm actually not in the 'Endwalker sucks' camp here - I enjoyed it and I'm not willing to pretend otherwise. And I wasn't exposed to the pre-launch marketing/hype since I didn't start playing the game until shortly after EW launched and avoided anything related to it for the sake of not spoiling the MSQ for myself. Playing the MSQ at my own pace, I didn't actually reach Endwalker until the following March.
And I watched the Footfalls Cinematic right before I started Endwalker. To this day I still think that cinematic was incredible - I recall watching it that first time. The music and the lyrics, the promise of a 'end of the world' scenario story. The emphasis on the moon and the question of it's role in the story, not to mention the question of why the Warrior of Light was on the moon - alone no less! I was completely blown away by it and couldn't wait to see how it would all translate into the story.
But even as someone who very much enjoyed Endwalker.... I don't think the story quite lived up to what the cinematic portrayed.
As you say, 'The Final Days' should've been a world-changing, almost apocalyptic, event - but it doesn't feel as if it had as big an impact, or long-term consequence, on the world as Dalamud/Bahamut did.