An affordable VR console with a lot of big games would be sufficient for VR mass market success, but likely some of those big titles would be automatically exclusive for that console, namely for first party titles. Those would first be made just to get the console off the ground. Sony made "Horizon Call of the Mountain" probably just to sell more headsets, not because they expected to make money with it. The install base is likely too low for that. A third party publisher wouldn't have an incentive to make such a big game. Valve probably also didn't earn anything with Half Life Alyx, they wanted to make their Steam market bigger.
The problem with Valve is that their platform is PCs, and a gaming PC + VR headset is too expensive for most people, who often don't already own a proper PC. The problem with Sony is similar: The PSVR 2 is not a standalone console, but just an add-on to a PS5, and PS5+PSVR2 is too expensive for people who are just interested in VR. It's like trying to sell a Game Boy which requires you to already own an SNES for it to function. It would be a flop.
The Meta Quest 2 is in a better position, it's standalone and rather affordable. But Meta can't support it with big games like Sony or Valve could. Meta doesn't have the expertise and probably also not the will to develop expensive AAA games in order too push Quest sales. They are more interested in the metaverse than in becoming a games company.
Nintendo could perhaps make a successful VR console, but it would require massive investments in AAA titles, which would be very risky for them, given their size. And Sony isn't interested in a standalone system.
Microsoft would be more likely. They have huge cash reserves and can afford to lose large amounts of money until they become profitable, as they've shown with the first XBox. But I they haven't shown any ambitions so far to invest billions into an "XBox VR" console and corresponding AAA games.