What
@Cugino83 said seems like your best bet for getting em working again.
Also if you have it conencted to a USB hub instead of the motherboard that might cause issues , also also you should try moving it to a USB2 port if you have any and it's currently in a USB3 cos since WIn10 usb3 has been kinda messy. I had a bunch of issues with external drives not working properly on 3 even though I had the latest mobo drivers for it, maybe this is still a thing on win11.
If you do go new joys, I think it will depend on what style of gamplay you do. Yoke with a throttle is fun and can be very immersive if you like chill flying and enjoy peacuful activities like space trucking and mining and such and fits great with large less maneuverable ships (it's also great for flight sims like MSFS) but it's cumbersome and slow to handle in a dogfight. Get dual sticks if you do more active flight like combat and racing and hardcore stuff cos it just works better with the current 6dof flight model . You will be circle strafing more than anything else so it helps to have granularity, and it's also great for pulling stunts and smooth landings.
Personally I'm happy with my single VKB NXT (1st gen non-evo I think) and just a keyboard, although you could also do offhand stick and main hand mouse as well, that works great for some!