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

[Brinne]

I wish you (general you) could have seen how absolutely PSYCHED I was in 5.2 when Venat first was revealed and namedropped. I was so, so excited for her - oh my gosh, Venat! They chose the name Venat for Hydaelyn's human form! And, and, and, a charismatic woman with the steel willpower and the ruthlessness to do whatever she saw was necessary, even if it meant tons of innocents as collateral damage? And then manipulated the information the world had so she wouldn't be culpable for it? My brain was essentially on fire. I actively didn't want her to be mustache-twirling evil either - I found the Hydaelyn vs Zodiark conflict as described in 5.0 to be compelling and tragic as it was - but I wanted the narrative to embrace the fact that she was willing to take methods, even for a goal that we may have agreed with, that were disturbing and questionable. And ideally, for the protagonists, unacceptable.

My friend played ahead of me in Elpis, and mentioned meeting Venat, and the first thing out of my mouth was "Is she cool!? Please tell me she's cool!"

Which makes it all the more bitter that, in a lot of ways, I got exactly what I was hoping for, except the narrative 100% took her side and reassured us she was the kindest, most loving person who truly and unironically had no choice but to destroy the world and be responsible for the deaths of unimaginable numbers of people - and we should all be very grateful to her and adore her for it.

Something I've said about other pieces of media is that I can like just about any kind of character who does anything - as I've said, the majority of my favorites in other stories are those who are quite terrible people, and I've done my fair share about gushing about my appreciation of Hermes in this thread with the read of him just being incredibly selfish, hypocritical, and awful. But the one thing that turns me off, hard? Narrative dissonance in trying to forcefully reassure me that a terrible person isn't terrible. Sympathy is fine. Apologism is not. That is the one thing guaranteed to turn me on that character.