It would be great if games implemented it for aiming, but I am not sure that they will for sure. Given how few third party developers add a gyro-aiming option when they release a game on the console when most first party games have it in some way.
It will make for an interesting dynamic for games with cross-play with other consoles where implemented though.
We could hope that Nintendo exposes a mouse like interface when it's in mouse mode, which could help a lot for adoption for cross platform third-parties.
Dealing with Switch specific gyro info, sometimes coming from two sources sometimes from one must have been a PITA, especially for games using a cross platform engine.
The current motion controls for the pro controller work well, but a mouse + single hand controller setting could work as well.