Using pihole DHCP setup causes most traffic to fail

From the Pi terminal, are you able to dig and ping these domains successfully? If yes, then the problem lies in the browser and its settings. Or, you may be blocking some element of the page that the page needs to load in your location (the referenced tools can help here). Have you tried an alternate browser? Have you cleared the browser cache and restarted the browser?

Using Chrome browser on Mac (latest OS and latest Chrome), with no ad-blockers other than Pi-Hole, the following domains are requested when https://www.nba.com is loaded in the US (and the page loads normally):

* nba.com
* www.nba.com
* cdn.nba.net
* fonts.googleapis.com
* dpm.demdex.net
* agility.nba.com
* secure-us.imrworldwide.com
* www.googletagmanager.com
* cdn.branch.io
* js-sec.indexww.com
* static.criteo.net
* c.amazon-adsystem.com
* i.cdn.turner.com
* www.ugdturner.com
* cdn.krxd.net
* www.googletagservices.com
* d1z2jf7jlzjs58.cloudfront.net
* s.cdn.turner.com
* 5165526.fls.doubleclick.net
* fastlane.rubiconproject.com
* ib.adnxs.com
* data.nba.net
* geo.ngtv.io
* fonts.gstatic.com
* adservice.google.com
* lp.nba.net
* js-agent.newrelic.com
* nba.demdex.net
* z.cdn.turner.com