I don't think it's a content issue as much as a comfort issue. Literally everyone I know who bought a VR headset, high-end or low-end, has said more or less the same thing: It's impressive, but it starts to hurt after an hour or so. Hard to get and stay immersed when you're in physical discomfort.
I just got a new different headset (Quest Pro, coming from an Index) and I had to figure out how to make it comfortable enough, because you're right that out of the box, they rarely are. (Except Index, which is still one of the best all-around headsets, even years on)
But I figured out a comfort fix because I'm hooked: I'm in VR 10-20 hours a week these days, because I use it to transcend my physical body and hang out with friends around the world. There are even sleep worlds in VRChat where people literally sleep in VR! Also, less intentionally, sometimes you're hanging out and someone passes out on the couch and starts lightly snoring. As above, so below. :)
In some ways, sci-fi is here! It's just, like bars, beaches, or boardgames, not for everyone.