It was before my time on the Lore RP/forum, but no one's mentioned "The Trial of Vivec" yet. One of the possibilities for his fate is that he left for Aetherius when he chose to (pretending to go along with a public trial until that moment).
I mentioned that one of the
possibilities of Vivec's fate was CHIM. I was meaning to imply canonization for the Trial of Vivec there.
It's left wide open by the DEVS. I think that it's left vague because no matter what happened, eventually he no longer existed on this plane and therefore his spell on that rock over Vivec City would wane. Even if he achieves CHIM and becomes conscious within the Godhead, and is therefore technically still alive, his presence on Nirn or perhaps even his ability to manifest here or care for the things that happen would have possibly diminished. Or perhaps, as per the Loveletter, he had intended to test the Dunmer all along.