Destroying the heart of Lorkhan made the Tribunal (Almalexia, Vivec and Sotha Sil) a lot less powerful, IIRC they where still more powerful then normal humanoids.
Then in Tribunal Almalexia murders Sotha Sil and Vivec dissapears, as you might know the Ministry of Truth is actually a moon that came crashing down but was stopped by Vivec, appearantly it was a time delaying spell or something (a wizard did it) and when Vivec dissapeared it came crashing down with all of the force it initially had, causing Red Mountain to erupt, earthquakes and other natural disasters.
And then ofcourse the argonians invaded and that's where we're at right now in Skyrim.
My god I hope they release expansions soon, from the heightmaps of Tamriel they found I hope we'll see at least part of an entirely new province, maybe post eruption Vvardenfell or some before unseen province (I've always wanted to see Blackmarsh, but I don't expect this to be done until an entirely new game get's made).