For blocking ads it works ok, I’ve found it doesn’t work well for AppleTV apps as all the ads are seemingly baked into the video streams. But VPNs are better for accessing geo-restricted content, which previously was very difficult on the AppleTV. So a pi-hole is quite a different use case.