By the time Meta figures out that headsets are not the way, they will be bankrupt. No one wants these things. People buy them, use them once or twice and then forget about them.
FWIW my kids still play on the Quest pretty much every day. Gorilla Tag is apparently the bees knees.
I only get on like once every couple of weeks however. Mostly just playing through stuff I bought off of Humble Bundles or trying not to suck at Beat Saber.
I work for a reasonable sized enterprise, I can literally not think of a single use for these VR headsets, apart from some novelty, such as trying to make compulsory training more interesting. And they aren't going to buy everyone headsets for that, nor are they going to deal with the faff of sharing them out to teams (hygiene hassle).
Has that been your experience with gaming? I was considering taking my first dip into VR with the PSVR2, but worried that as you say, it will end up collecting dust.