I can confirm that the game works with a Microsoft Sidewinder Precision Pro joystick and have played the game to 100% that way. Mind you, that was in 1999 on Windows 98.
I’ve not tried it with an Xbox controller since, but my (now rather old) Sidewinder still works with the version of Rogue Squadron I got from GOG. Make of this what you will!