"...many people...finally say "The Church is just plain wrong and I have to follow my own conscience on this." Watershed event for many in their accepting adult responsibility for their faith lives."

That is the adult thing to do - although the consequences are extremely grave.  If you cannot accept the Church's teaching, and you feel your conscience is paramount  to the Faith (which is a mistake by the way - "conscience" or "heart" or whatever is typically a deceiver and should always give way to the Faith) then you are free to take your wallet and your immortal soul and roll the dice attending another church.  Maybe it will work out for you and God will have mercy in your final extremis even though you walked out of His true church to attended a false one.  Maybe.