Docker Pihole + Unbound = Host Unable to Resolve Domains

Macvlan networks are not able to directly communicate between the container and the host OS.
This isolation is by design, but you can use a "shim" network interface to allow this communication.

Personaly, I never create the macvlan using a compose file.
I always use docker network create <options> command to create the network and use it as external network.