Yes, this should be the case.

If you set manual dns server 192.168.8.174, it will be used by both vpn and non-vpn. The router will first respect the dns settings then dns from vpn.