I asked this before for exactly this scenario but have not received a response, what method(receiver) are you using to connect your 8bitdo SN30 to Windows? (8bitdo usb adapter, bluetooth USB dapater, built-in bluetooth).
In order to relinquish control from the 8bitdo, you would have to disconnect the adapter and not just turning off the controller. The xbox one controller is the exception, you can simply turn off the controller without disconnecting the receiver and it will relinquish control (unless you are also connecting the XB1 controller via bluetooth to windows). This is not practical but attempt to do this first so we can make sure the autoprofile switch is working properly
Testing Xbox controller
- Disconnect 8bido adapter, turn off SN30 controller
- Turn on Xbox controller
- Run retroarch and test Xbox controller
and then
Testing SN30 Controller
- Turn off Xbox One Controller
- Connect 8bitdo adapter, Turn on SN30 Controller
- Run retroarch and test SN30 Controller
Assuming this works, you will be at the same point I am at. I am still trying to figure out how to switch controllers without disconnecting the receivers or turning off controllers.