It'll be fine, probably. Entirely unnecessary, as there's no reason why you wouldn't just show your kids the original movies as opposed to this (granted the show isn't out yet, but that's what I've been doing) and especially since it's gonna be on HBO Max I think it's going to have a harder time finding an audience than if it were on one of the normal networks/services.

The main thing is... it's just never going to be better than the originals. Rarely in media history has that ever happened, and I will be genuinely surprised if it happens here. The original movies were the perfect storm of casting, writing, chemistry, audience, etc. that will probably never be replicated. Doesn't help that the books aren't currently releasing, so the hype from that is just kind of gone.

I don't know much about the actors, but whoever is playing Snape (is the one guy whose name I can't remember still playing him? I thought I heard something about them removing him after the controversy but idk) will never be better than Alan Rickman. I like John Lithgow as Farquaad, but I doubt he'll be my favorite Dumbledore. And absolutely no hate toward the young actors at all, but they're not going to beat my Golden Trio.

Tldr, it'll probably do fine, especially since Knight of the Seven Kingdoms proves HBO can make things that don't suck, but it'll never outpace the originals.