Depends. I get horrible carsickness just riding a bus or a plane, so I get some motion sickness in VR no matter how high of FPS it is, no matter how low the latency. I sometimes get motion sickness playing games on my monitor too though, so I'm definitely in the most susceptible category for this stuff.
Like other said though, the worst of it goes away after using it a few times. I noticed though that if you're really susceptible to motion sickness, you basically need to adjust to every type of locomotion or movement individually -- and any vehicles or cockpits are still totally unviable for me still, from No Mans Sky to American Truck Simulator.
Though it's not just one kind of locomotion either -- I adjusted to head-position-relative smooth locomotion with a joystick on a flat surface at a walking pace, but what about downhill at a running pace, on horseback? Then I have to spend another week getting used to THAT. Or what about smooth locomotion circle strafing in a dungeon around a bunch of skeletons? Another week. And I still can't handle any camera rotation at all.