There is a considerable difference between saying Francis "is hardly a model Catholic for us to follow" (various popes of the past can be described as such) and Vigano stating he's not actually pope at all. The excommunication of Vigano was basically just a formality; he had essentially excommunicated himself already, which is why he didn't seem to care much about it.
Since you put the quote in a quote box, it gets vanished when I quote you, so here's the portion quoted from Sheen:
“[Satan] will set up a Counter-church, which will be the ape of the Church. It will have all the notes and characteristics of the Church, but in reverse and emptied of its divine content.... The False Prophet will have a religion without a cross. A religion without a world to come. A religion to destroy religions. There will be a counterfeit Church. Christ’s Church will be one, and the False Prophet will create the other. The false Church will be worldly, ecumenical, and global. It will be a loose federation of churches and religions, forming some type of global association, a world parliament of Churches. It will be emptied of all divine content; it will be the mystical body of the Antichrist. The Mystical Body on earth today will have its Judas Iscariot, and he will be the False Prophet. Satan will recruit him from our bishops.”
This quote is shared online as some kind of prophecy of the future, but is really taken out of context. In truth, Sheen's prediction failed to come true, because Sheen was talking about how communist Russia would be a key point in such a church. As he notes in a remark usually left off in these online quotes:
"The last century rejected the Church because it was infallible; it refused to believe that the Vicar of Christ would be immune from error when he spoke on matters of faith and morals as chief shepherd of Christendom. But the twentieth century will join the counterchurch because it claims to be infallible when its visible head speaks ex cathedra from Moscow on the subject of economics and politics, and as chief shepherd of the world communism."
Given that Russia dropped communism more than three decades ago, this seems rather unlikely to occur. Even if Russia at some point does decide to bring it back, the fact we're in the 21st century and this hasn't happened yet (Sheen said it would be in the twentieth century) shows that Sheen was simply wrong in his prediction. To be fair, he didn't portray this as some kind of prophecy from what I recall.