Yes, you have indeed got it "all wrong". Finally, some humility and insight. But no, the Holy Spirit has not "been remarkably unsuccessful in communicating" his will. He has communicated it with impeccable brevity and clarity over the millenia. It's just that institutional Catholicism, like insitutional ancient Judasism, refuses to listen fully.