It's definitely going to have a shaky start, but I really cannot predict how good it's going to be. If there's one thing I learned about TV adaptions, it is to expect uncomfortable changes such as Link's inevitable speech. What really makes me curious is how this could influence the future of the franchise if it goes well; my pessimistic old self foresees two outcomes: 1) It goes well financially and thus gives Nintendo the idea to recycle their success or 2) It turns out to be the stepping stone the series needed, but a rabid hatebase discourages Nintendo from exploring ideas like this.
As for the show itself, I'm not going to lie, I'm expecting it to be a cliche storm; it will contain the prehistoric Chosen One BS, Hijacked by Ganon, Mary Sue frenzy stuff. That's all a given, considering it's Zelda, but when they say it will be like Game of Thrones, I fear horrible things. Not that I hate GoT (I haven't seen it yet), but that this show might end up stealing plot devices or even character concepts just because the writers were too lazy.
This is a big adjustment for some of us, and if I am to advise, I recommend keeping an open mind, while still being prepared for disappointment.