So from where I'm sitting in my middle class suburbs, it's certainly not dead, but it's basically the modern equivalent of those actuated flight sim entertainment experiences from the 80s/90s.
VR seems to be much bigger among the perpetually online. For us normies VR is hardly a blip on the radar.
I still don't even really understand what Horizon Worlds or the Metaverse even was, or if there's a distinction between the two. I've heard of VRChat, but from the little I've seen, it seems extremely unappealing.
I still think that most people don't want to strap a computer screen to their face, for any reason. I've done it, it's not very pleasant.