I agree on a lot, and I'd like to offer my take on this. So the long and short of it is D&D are stuck between a rock and a hard place with female characters here, and are choosing to just bash into both instead of escaping the jam.

On one hand they're catering to Twitter (and the like) every since Season 5, who is rabid at any way, shape, or forum where women are portrayed as less than stellar. Twitter likes incredibly 1D badass females (this is why Ayra and Lyanna are so favored there), and not much else. Take for example the turnaround from E3 to E4 this season. Twitter went from 'YAS QUEEN SLAY' with Ayra and the Night King to mobilizing accusations of sexism against GoT because of Dany and Sansa in a single episode. This has been repeated over and over during the series, especially the early seasons where the book material does not have female characters are legendary badasses, but as human, capable of mistakes, but also capable of greatness....like any single man...because GRRM has shown time and again he considers both sexes equally capable creatures.

On the other hand they have to remain (somewhat) loyal to the Book Material, where again GRRM shows women just like men. Capable of being anything from good, great, bad, mediocre, horrible, downright awful, stupid, brilliant, wacky, insane, and so forth because well women are human...go figure. This creates some conflict, because Twitter and co hate any weakness in female characters, and mobilize chainsaws and 'cancel' culture if things get to bad in their views. This then means, and has meant, D&D write their female characters to be incredibly badass characters (e.g. Ayra and Lyanna) who can do no or limited wrong (a running theme for the past few seasons) for as long as possible. Weirdly this has also meant male characters are relegated to idiots (Varys and Tyrion), whipping boys (Jon), or whatever the fuck reverse Mary-Sue thing Euron is (but male characters are another matter). Anyway, THEN the ACTUAL PLOT of GRRM kicks back in and the female character has to be given weakness or vulnerability (like, idk, a normal human), which usually means a meteoric fall from the absolutely incredible heights they were at in like 1 episode (or 15 minutes in the last episode). This then feeds Twitter and accusations of sexism, misogyny, and what not towards women, as they've grown used to these characters being incredibly 1D and zinger heavy for 2-3 seasons.

The result is that Twitter (who let's face it, is the vast majority of viewers) are not happy, and at the same time people like those who frequent here are not happy; because quite simply the female characters are not living up to either of their expectations (e.g. twitter or book-based expectations). Further, when the female characters do attempt to try to live up either of their expectations (for either retweets, or to honor the source material) it's usually done so poorly, so in a rush, and so out of the blue it's almost insulting. Like suddenly Dany is mad in 1 episode, suddenly Ayra is loyal to Winterfell and then not in 2 episodes, Sansa is calculating and cleaver after learning from the worst political operatives in the realm but then is like that 'because rape.' The list goes on.

​

Now there's also D&Ds incredibly inability to write convicting characters in general without source material, which has also been why the latest episodes seem like a soap opera now.