My brother has a VR headset and I've played a few times. I really enjoyed it, but the time it takes to set up was a bummer and we had a lot of problems calibrating. He doesn't have the space to have it set up permanently, so any time we use it, it involves a laborious procedure, which definitely sucks some of the fun out of it.
I didn't get motion sick, though I did get a few very small twinges when playing this really badly put together playerunknown clone (but that mostly came from movement being really strange and choppy framerate, which was the game's fault, not the rig). However, I do have an iron stomach. I think motion sickness will be reduced (though not entirely eliminated) as they increase FOV, framerate and resolution of the headsets, however, I still think a good portion of people will naturally get motion sick playing. My girlfriend can't use a phone while she's in a car because she gets terrible motion sickness and for people like her, I think VR will always be a pipedream.
Overall, from my experiences with it, I think it will always be a higher-end device like the setups that racing game enthusiasts tend to build. Using a proper racing setup (not necessarily with the whole haptic feedback reactive seat things, just a really nice haptic steering wheel/pedals combo thing) is always a ton of fun, but most people don't do it because the number of times they will use it in a year won't outweigh the cost unless, as I said, they're a racing game enthusiast. I think VR will occupy a similar niche, with the majority of people skipping them because of a number of reasons and a small but dedicated number of people owning some seriously impressive rigs.