The Rift S is great, not only in MSFS but other games as well - I’m sure you’ll be happy with it. Just be aware that the resolution is lower than the HP G2, so you’ll probably need to zoom in on glass panels to read small text.
I’ve been using my Rift S in DCS and iRacing up until now and it has been flawless. Only one gripe in DCS - distant planes look a bit blocky or distorted, but that is down to the resolution limits of the headset. And by distant, I’m talking about 5+ KM away. Probably not an issue in MSFS as you aren’t trying to target them 