I've installed it on Ubuntu and Raspberry Pi but when I went to my friend's house today to install it on his Debian 12 laptop I couldn't get it to work. It might have just been general networking problems but is Debian shipped without a package that's needed for pihole?

The result of my attempt was strange- dig showed the computer was using 127.0.0.1#53 for DNS resolver, the pihole dashboard in the browser showed the queries, but Firefox kept saying it can't find the page. It was kind of embarrassing since I talked up pihole a lot and couldn't get it to work lol.

Why would you install it on a workstation when you can just use better tools like uBlock Origin?

Pi-Hole is for devices that doesn't support decent adblocking tools, like your smart TV.