The show is going to give a lot of people what they want: lots (ie nearly 20) of dragons, lots of Targaryens, wild sex shyt (including secret romances, incest, and gay shyt). Basically a lot of the things people liked about the last seasons. Remember, twitter is reflective of only 7% of the US. When I talk to people like my parents and other folks who aren't online...like liked the last two seasons. Do they have shytty taste? Sure lol. But if they liked that, they'll like this.
The problem the show will face is that while it'll feature some standout characters and legend - Daemon Targaryen, Cregan Stark, Criston Cole, etc - there isn't a whole lot of Martin dialogue to pull from. Game Of Thrones worked largely due to the characters and the dialogue, much of which was ripped straight from the first three books. Without a similar treasure trove, this show is going to rely on the show writers. Will they be better than D&D? That wouldn't be hard. But they're gonna have to be great to truly bring all these characters to life.
Assuming they follow Martin's plot and characterizations it could be a great show, but they have to knock the writing out the park. There won't be a Tyrion, Arya, Dany, etc type characters for people to truly latch onto IMO. Some will have potential to truly resonate though, like Nettles...who could be the biggest standout if they cast her right. She will almost certainly be black, too.