Router is not smart as you think, for consumer grade router it just forward the data packets from LAN side to the WAN side. it has no idea about the applications.
When a Windows application request a DNS name let's say Apple.com,
the application actually requests the built-in MS DNS client (comes with Windows) in the background to make a query about apple.com. App sends data --> network adapter --> router. Apps don't talk to router directly. If the app does not request a FQDN (full qualified domain name, like
www.apple.com or
www.facebook.com), the traffic stay in your LAN.
When you have more than one network adapters (including wifi), Windows will make a network card priority list and will only use the highest one and ignore all others, unless it has built-in proxy settings (or Winsock) you can set like I mentioned earlier (Chrome/Edge/Firefox for example)
Introduces the Automatic Metric feature in Windows for IPv4 routes.
docs.microsoft.com
Windows also does not allow you to set default gateway on more than one network. So if the app is requesting a FQDN on the internet, it will only send data through the adapter with a default gateway that has been set.
Describes the connectivity issues that occur when multiple default gateways are used in TCP/IP configuration options.
docs.microsoft.com
Exactly what application you are using that needs to use another adapter/router/WAN ?
And have you tried ForceBindIP utility that I also mentioned earlier?
==
Need to leave. Won't be able to add more until later in the day.