fww no fast paced 3D game (eg Doom, Battlefield) got me sick, but playing VR got me some sort of deeply disturbing motion sickness after 1h of use and it lasted over 12h, so in my experience those are not comparable.
That was to me the major pb with VR adoption, i'm really amazed people don't mention it more anytime Meta is discussed.
For games without smooth locomotion, VR sickness usually isn't a problem unless it's a crap game that stutters or has other problems.
Honestly, this sort of game is probably a worst-case scenario for motion sickness. Like most FPS games, it's designed around unrealistically fast player movement, which is a recipe for nausea -- and the janky physics and low-resolution models and textures of a nearly 20-year-old game don't help, either.