Raid 0 doesn’t increase the risk of failure. If you use a single disk as your Windows drive and it fails you’ve lost windows. If a disk in RAID 0 fails, you’ll lose windows. So the issue in both cases is losing a disk causes you to lose Windows. It’s very much an issue of disk reliability (and SSDs are more reliable than traditional hard disks)
Raid 1 (a mirror set) protects you from single disk failure but the downside is lower performance than RAID 0 and you only get the capacity of a single disk whereas in RAID 1 you get the sum of the capacity of the disks.
I run M2 SSDs in RAID 0 as my system disk and definitely get better performance than from a single disk.
I fun MSFS from a separate SSD dedicated to MSFS.