Can someone explain to me how a dragon resurrected turns into a dragon that spews ice, manages to make a hole in a wall made of ice ?
You go through a whole programme of the walkers killing everything in their path, only for a diminutive female to appear from nowhere, perform acrobatics like an Olympic gymnast and defeat the whole arm with possibly the smallest piece of "dragonglass" she could find ?
Not exactly "The Ride Of The Rohirrim"
Because D&D were probably told that the books will end with;
1) the wall being destroyed/the white walkers invading the North
2) the Night King (Night's King) gets an undead big burny seagull to fly around on
3) Jon Snow, as the Prince Who Was Promised, fights and kills the Night King
But because the source material isn't written yet, D&D are too fecking thick to come up with their own ways to get to points 1 and 2, we ended up with the shite we got. And with point 3 they wanted to, in their own words, "subvert expectations" because their favourite moment in the books is the Red Wedding and they loved it for all the wrong reasons. Rather than "actions have consequences" they thought it was just "shocking".
As an additional note - the show became a parody of itself, desperately trying to recapture the shock value of the Red Wedding, or the Viper and the Mountain, or the mess they made of the book's Dorne plot, so that dickheads standing in a bar could post reaction videos on YouTube. It was rife with these videos and D&D knew it made the show more popular, but it was a joke - certainly a joke that was funnier than the multiple ones about Varys having no cock Iol.