Pihole only see dns query. It doesn't see the full url. On the other hand, ad block extensions can see the whole url and can decide to block them while allowing other requests to the same domain through.

I think you should install both though. Pihole can block ads on apps, and can block CNAME cloaking.