Latest Steam Deck update will warn you if an Xbox controller needs upgrading
(www.gamingonlinux.com)
It's not possible as xinput doesn't support gyroscopes, the controller simply doesn't report that data. The "Switch" mode is setting it to be a mostly standard HID/DirectInput device so that all of those inputs can be accessed, but that requires something (Steam Input) to sit between the controller and the game to map the inputs together, and the game has to also support non-xinput controllers - otherwise you are just mapping them back to xbox inputs. The exception is a game that support directinput... well, directly. Like sim racers etc.
There is now the option of going "hardware" Steam Input as well, as is done by the HORIPAD for Steam, but it is something the controller has to do.