@McMurphy maybe its being redirected upstream? There are currently multiple threads about on how nord is intercepting dns traffic..
If you want to know if your override is working.. Sniff your traffic.. A domain override can be used on just a resolver as well.
Also keep in mind using the diagnostic lookup window isn't a good choice for this sort of test, because depending on how you have it setup, pfsense would fallback to or could just ask what is in its dns settings.
Here.. I setup domain override for openvpn.com
You can see when I ask unbound for it from a client on my network - it tries to ask 1.2.3.4 via sniff on the wan interface.
settings1.jpg
You can see from your response there - it asked loopback, got no answer, but then asked 8.8.8.8 directly.. This is pfsense asking, not what unbound did via its settings.. You would prob need to set this to do not use external..
ignore.jpg