PiHole as a Upstream DNS

This would be the expected behaviour for your setup.

If your Windows DC and BIND servers are ECS-enabled, Support for add-subnet option from dnsmasq (ECS/EDNS0 Client Subnet) may be relevant for you.