We don't have the same issue I think. My issue is the right stick completely stuck on the right, and this happened while playing a game. It's just a manufacturing error or a faulty stick.
If I remember correctly, your issue is one of the controller not working at all, which supposedly is tied to a niche software issue, which explains that you can still bypass that problem and play with your PSVR2 by doing some weird stuff
That also explain why some people had to send the full system back and not only the faulty controler.
I tried to go on Horizon menu and do what you advised me on your last post (thanks again man, btw!) : nothing worked, and I can see the stick stuck on the right (as the controlers are 100% materialized on screen) without any possibility to move it even for one millimeter.