Well how could it? Of course the DNS provider needs to know the domain you want to look up - otherwise how would they be able to look it up?
Still it would fulfill the OP’s wish: He wants to hide traffic from his ISP, so if he chooses a DNS resolver other than his ISP, and encrypt transmission, goal is achieved.










Most people don’t know: There’s a multiplayer variant of Civilization 1: CivNet. Barely playable today, as it’s a Windows 3.1 game. I loved it till late in the 2000s.