The broader question is
What the heck is going on in Christ's True Church?
a lot of hideous evil, that's what
But Jesus DID tell us that few believers (not pagans, but BELIEVERS) would make it to Heaven... He even said that those who do great deeds in His name would be rejected..

I believe that is either Mt 7:21 or thereabouts or (and/or) Lk 13:24 and thereabouts..
He spoke of building your house on sand.. sand being: the ways of the world, the flesh and the devil, all of which dominate society but then, it has always been that way.. we just forget bc we didn't live in those old days which we always tend think of as being so mcuh better, more moral, etc.. Well, it IS true that the 50s in the USA were far more moral and wholesome than 2000s but human nature has always been sinful and God rejecting
In any case, people who reject the Church just bc most of its members are egregious sinners... well, I find that short-sighted, even though I can totally understand.. I have often felt very rejecting of the Church msyelf, for same reasons listed by OP
But Jesus said that he would not.. promised that He would not abandon us, would never "forsake" us.. and by gosh, that means NEVER (Mt 28:20)
His Presence is still in His Church (although of course, He is free to leave a given Church if...)
You can't abandon Jesus and HIS Church just because members therein are sinners.. In that case, you would be Church-less and Jesus spoke of the importance of the Church.. Mt 16:18.. Then we have our personal experiences that also testify to the efficacy of the Church... I can say for myself that i NEED.. don't just want but NEED that Real Presence.. and so I say that all humans need "it' also... (God is no respecter of persons, as it says somewhere in the Word)