Disclaimer: I am no expert by any means.
With that being said, as others have said, a DNS is like a phone book. By using PiHole with it going to a privacy respecting DNS service, you in theory eliminate being tracked by a DNS provider, but you do nothing to prevent your isp from tracking which ip addresses you access, and you do nothing to prevent search engines tracking which results you click on, you do nothing to prevent your web browser from tracking your browsing (especially on Chrome and Edge).
In summary:
DNS lookups: yes
ISP with IP addresses: no you would need a GOOD VPN or TOR and either one properly configured
Web browser: no, you need at least Firefox with data collection turned off, preferably with something like ublock installed.
Search engine: no, requires more research but supposedly duckduckgo and eccosia are privacy respecting *citation required
Wow this sounds a lot like my outlook with Ff7 remake. I begrudgingly bought it on steam when it was on “sale” for the still too high price of $40, and when it was good it was great, but other than one mission it is just the story of Final Fantasy VII up through Midgar with a stupid amount of boring fetch quests to pad the time. Saying it is maybe 33% fun engaging game/story 67% boring fetch missions or “go kill this boring monster” over there is in my opinion being very charitable.