Of course the prophecy was wrong. It was bs to begin with.
This. It all started like 3000 years before the events in the game, when the oath-breakers pissed Azura off, so she made up this "prophecy".
Wonderful game but when looking in hindsight, its almost we wasnt the hero of the story but more like the start of a chain reaction that leads to morrowinds destruction...almost as we are a catalyst ourselves.
The blame doesn't lie with the Nerevarine, but with Vivec and the Dunmer, bunch of foolish "patriots".
If Red Mountain is Green by the time Vivec comes back, then I'd expect him to gladly take credit for the destruction of Morrowind (or letting true beauty bloom).