Motion sickness in games where you have thumbstick movement is common, but for games where your movement is only based on IRL movement, like Beat Saber, motion sickness is much more rare (and severe motion sickness almost unheard of).
That matches my experience -- I could play Beat Saber with no problems at all.
The sad thing is that it's like saying, "You can play any game on this system, as long as the game's name starts with the letters A-D. You can't play any game whose name starts with E-Z, though!" You're going to miss out on a lot of great stuff, and frankly, there's tons of non-VR games to keep me busy forever.