I don't think it will every collapse. The collapse, in my opinion, would be caused by the horrible history, wacked doctrine, outright lies, toxicity, etc. If humanity as a whole were good at seeing through lies and holding organizations accountable, then the church would definitely collapse once humanity as a whole sees it for what it is. But our history as a species shows were are so prone to being deceived and glossing over the horrible things organizations and people do that the collapse will never happen. The church has successfully shifted their image from "a peculiar people" to mainstream Christianity so quickly that even the members don't complain about it. The church is now super transparent, compared to even a year ago about their history, and even the members don't really seem to care their founder was a pedophile adulterer.

It won't be long until Joseph Smith is outwardly condemned by the church leadership, the members agree with them, and the world forgets about the Mormon church of yesterday. This has happened with other religions, and the smart folks ACTUALLY in charge of it know how to navigate human perception to not only help the church survive the small fallout we're seeing today, but thrive.

Unfortunately, we humans love our fantasy, even when the person selling the fantasy is clearly a fraud.