Update: I found the fix. I had to go in my Unbound DNS settings and add an ACL to allow the Wireguard network to access DNS. Now, I can point the client to my OPNsense system for DNS and it works.
- have 127.0.0.1 as the system name server in System > Settings > General