The main difference to my knowledge between an ad blocker and pihole is while a ad blocker downloads the ad but doesn’t show it a pihole blocks it from being downloaded.
In addition you can block anything(not just ads) so if you want to say block reddit you could add *.reddit.com to the block list and it will block it even though it’s not a ad service.