I found a discussion from 2018 about this that seems to imply you have to have two addresses on different subnets, but I’ve never tried it before. Take a look here:
It’s kind of the opposite from what you’re trying to do (they were trying to do Ethernet for internet and Wifi for internal only), but it might get you further along at least.