It's a matter of perspective. If Meta had been marketing their device as a family game console, then yeah, the Quest 2 would have been a success. The problem is that Meta was banking on VR and their particular take on the 'Metaverse' concept blasting the doors wide-open to a revolutionary new market segment in VR social media technology -- They wanted to be the kingpins running the lion's share of VR-centric social infrastructure, the way Microsoft dominates in OSes and Google dominates in web searches. To that extent, they planned for their technology to achieve widespread adoption in multiple key areas in society, such as home productivity and the work place, rather than remaining primarily leisure/recreational.

So, yeah, from the perspective of Meta's absurdly high goals of 'invent what is functionally an entirely new form of internet', the Quest 2 is a failure.