What's the point with that quite lackluster story in Endwalker?

[Solarra]

Lets not forget that the ancients themselves had the brilliant idea of sacrificing their own kind to forestall the Final Days. Both sides made haphazard choices. It wasnt necessarily being evil, just people having to make tough choices for saving their own kind.(pointless insult deleted - it doesn't help your argument)

If the 'brilliant' idea of sacrificing yourself to save the planet was a wrong choice for the Ancients, then surely that has to invalidate the scions' 'sacrifices' in Ultima Thule. They didn't know they weren't going to die.
Of course the Ascians were planning to bring everyone back and would have done so except Venat threw a massive spanner in the works by sundering the star and wiping almost all of her people and condemning Emet Selch to milennia of torment in the process.

Don't get me wrong, I'm not saying Emet Selch did nothing wrong, he did plenty of things that were evil and yet I understand and sympathise with his motivation; that's why I find him such an enaging character.
My main issue is that Venat is equally, if not more, culpable and yet the story wants the player to accept her as being good and insists we view her actions as justified and morally acceptable.

And if we are talking about haphazard choices how would leaving our star and going to another solve anything? Would they even get to a different star? Wouldn't the people on the ship succumb to despair and turn once it left the protective shield of aether on Etherys? Both Venat's plan and her back-up plan seem flaky, to say the least.

ShB did such a brilliant job of tying things up and incorporating earlier parts of the story, it was my absolute favourite expansion. EW just felt like the storywriters got bored/stopped caring/got told to finish it up asap and don't worry about the quality (take your pick).
The fact that the producer was surprised people even cared about the lore indicates a real disconnect between what he sees as important in FFXIV and what the players value.