@slo-bo-dan that picture makes no sense - are you hiding the names? And the full IP?
domain overrides would be for where you want to resolve a specific domain and all its records from a specific name server..
For host overrides they need to be fully qualified, and point to a specific address - so believe your just not showing what is fully there?
Also for clients to get the host override they need to be asking pfsense for dns.. Or the nameserver clients are asking needs to then ask pfsense..
edit: Lets do a specific example, maybe that will help you understand how host override works.
you have www.domain.tld out on the public internet that resolves to 1.2.3.4.. This is your pfsense wan IP, when you see traffic to 1.2.3.4 on port 443 you send it to 192.168.1.100 via a port forward.. This is how outside your network gets there to your website on www.domain.tld
Now internal you have some client on 192.168.1.90, and he wants to get to www.domain.tld - does his dns resolve that to 1.2.3.4 or if you setup a host override on pfsense to point www.domain.tld to 192.168.1.100
If your client on .90 resolves it to 1.2.3.4 you need to setup nat reflection. If your client is asking pfsense for dns, then a host override would tell this .90 hey just got to 192.168.1.100
But if your client is using say 8.8.8.8 or 9.9.9.9 for dns directly then no yoru host override would never work.