The main reason I have very little sympathy for Hermes is because his expectations were completely unreasonable. He was in a position where he could have at least advocated for change and was due to be promoted to an even higher position.
We see through the Elpis side quests that the Ancients are constantly taking feedback into account and improving the methods of research and the process of creation magic. He's held in high regard by many - so it's not like he would just be ignored.
The same can be said of Venat. A former member of the Convocation isn't going to be dismissed and she wasn't lacking in ways to prove that something wasn't quite right. We also know that Emet was aware that his memory had been wiped and that even when faced with a story he found hard to swallow, it was in his nature to investigate rather than risk Etheirys and his people's continued existence.
After all, Venat only needed to go and send Emet to go and speak with the numerous Ancients who saw Emet, Hythlodaeus, Venat, Hermes and the player character together to prove that something didn't quite add up.
Much like the caricature worlds in the Dead Ends, Venat refusing to have such a conversation is little more than a lazy way to try and give the illusion that the Sundering was 'necessary', as if anyone is obligated to go along with the whims of the very same nutter who decided to stand by idly and allow an apocalypse to strike her supposedly 'beloved' people.
It doesn't matter whether the writers, streamers or even many players fawn over 'mommy'. Since thankfully not everybody is incapable of putting two and two together and realising that the entire situation was completely avoidable and almost entirely Venat's fault. With the much cherished 'suffering' leading to pretty much all of the game's darkest moments thus far.
Of course, many of the same players fawning over Venat will gleefully declare that their precious self-inserts are 'heroes' for stopping whatever threat arises in the story at any given time. Which in itself is bizarre and rather amusing given the complete inaction of Venat.