Points in simplicty
- The Aedra never left
- To leave their connection must be broken, reality must dissolve
- The wheel is a particular circular object with spaces, a frame and a hub that rotates on an axis
- When a wheel spins things move outwards (why is Talos venerated in the Imperial and Nord pantheon, what in particular is the mandate?)
- Spokes are displaced outwards unless there are connections to those spokes, only centripetal forces will prevent loss of structure
- the spaces between the spokes,the daedra realms, envelop the wheel and cause friction of it turning (i.e preventing it from falling apart) and this manifests as their influences. Why did Akatosh develop a pact with Alessia to prevent the Daedra from conquering Nirn? Why was Molag Bal stopped from anchoring Coldharbour to Nirn?
What has been happening in the games is that significant events have been occuring and causing the loss of connection of the Aedra to Mundus. The Aedra have left, in absolute terms, in their own perspective. However, mortals, being simple beings, perceive the reality of that the Aedra haven't left (this is because they cannot comprehend their own existence from outside terms ergo the Aedra are still here). Progressively, throughout the history of Nirn there has been destruction wrought on the fundamental fabrics of reality. After all, Lorkhan tricked them and they are tied to reality but as long as reality exists they cannot leave. So, Akatosh, being the aspect of time, sets out his plans in motion. The elder scrolls allegedly are artifacts of his. The Amulet of Kings are his, Dragons are his, the Dragonborns are his. The Elder Scrolls fortold of the events of the games, as far as I understand, all of which result in the destruction of some artifact or causes some event to occuring indirectly or directly through the absence of the individual or because the hero did something or someone catalysed the events to occur in such a way *cough the daedra cough or the aedra cough*
In the case of Morrowind, Azura wanted to settle some petty squabble dispute with three people and instigated the destruction of Red Mountain and the Heart of Lorkhan. Now reality is dissolving, magic as of Skyrim has died. I could liken the less prominent (less involved that is) Daedra as wind wafted away from the main volume of resistance.
In the case of Oblivion, Akatosh essentially orchastrated this event from the beginning, as he had done so for all events. Why, indeed, did the Aedra plot in the Adamantine Tower and why indeed is the door locked and impenertrable? Doors open in time and all the time, as will that door. When that is the last tower standing, will the door open to see the departure of the Aedra for good and render the destruction of the Adamantine Tower? Adamantine is mythologically impenertrable, the door is eternally locked and there is no way to get through it. Ergo, when the door opens the Tower falls and creation is one step - or all steps - closer to dissolution. The Aldmeri Dominion want this too, but for their own ascendancy. Why would Akatosh tell Alessia to keep the dragonfires lit if he knew and deigned that this would permenantly close the realms of Oblivion to Mundus thus reducing their influence to almost nothing and allowing the wheel to keep spinning? In Akatosh's genius, he is fabricating the demise of all of mortals - those same mortals that worship him. It doesn't matter what the world does, the world is a background to the hero of the series, the man or woman or reptile or mer or beast and so on that for the divine favour smites the enemies and fulfills prophecies in all of their arrogance and conceitedness.
In the case of Skyrim, the prophecies have been fulfilled to herald the demise of Alduin. The Elder Scroll, as established, sent Alduin forward to the point in time when Akatosh knew that this would be the result. Remember, Akatosh is the aspect of time and those that know, have far greater perspective than those that don't. What happened in Skyrim is quite interesting, as surely the Dragons would further Akatosh's goal? But can we be sure that in fact the Dragons are in fact spawn of Akatosh and not just Alduin. Why is it that Alduin appears to be what people would associate with evil. He is stone-like, spiney and an embodiment of death and destruction, wearing the mantle of 'World Eater' - surely something so divine as Akatosh would not be paired with such a creature?
We might argue 'but nothing in TES is true 1!!111" and that "how can we be sure that Alduin is telling the truth". As he is supremely arrogant and superior, those people don't lie because they have nothing more to gain over another by lying - why would I lie when I know I am far superior, intellectually, physically and spiritually? Perhaps I wouldn't although we must examine the dragon under Red Mountain that told that mage about the theory of Enchanting two items at most - a blatant lie however this must be taken in its isolation because this is merely a mortal matter and demonstrates the superiority of dragons over men. By the mage asking the dragon, the mage is subjecting themselves to the authority of the dragon and therefore will believe anything the dragon says and the dragon can make the appeal to authority much more adequately and therefore they can stretch believability.
Alduin doesn't even care that the Dragonborn has 'defeated him' and it doesn't matter anyway, Alduin's soul is not absorbed as it is too divine for the Dragonborn to carry. Perhaps Alduin is Akatosh's creation to form a part of an elaborate plot to end reality and to eschew the shackles of Mundus on the Aedra who wish to leave but to themselves and a few others, have.
And perhaps that's why the world is fairly static beyond the influence of the hero. As the hero is the agent of time, the one to fulfill destiny and to bring about the end of creation, only the Hero's actions matter and cause the continuation of history wherever this person may be. Significant events don't seem to be alongside the timeline during the presence of the hero and they only occur when the hero is present. Why do characters wait perpetually in stasis for the hero to embark on quests and missions, repeating their schedules until prompted by the hero. So far, they've been gaining more and more autonomy which would imply that the connection of the hero's actions as the sole driver of the continuation of time in that brief period of history is indeed becoming less. History is shaped to the whims of the hero and that might also be why you could assign god-like as a descriptor to the abilities of the hero. The god-like Nerevarine struck down Almalexia in Sotha Sil's Clockwork City. The god-like Dragonborn fought Alduin and used the power of the voice to prevent Alduin from charring the world and so on. They are far beyond the capability of all mortals and are rarely surpassed only by other significant people.
So you ask, what about the Dwemer? Are they relevant? Perhaps they knew about this, because they used logic and science and also they could read and study Elder Scrolls with impunity. You have to find the Elder Scroll which allows you to access the time hole in the Dwemer ruins, it was in the machine. Perhaps, the Dwemer discovered this and perhaps the devices were developed (Sunder and Keening) to use the Heart to take themselves out of existence to avoid experiencing the dissolution of creation. The battle at Red Mountain resulting in the death of Nerevar (paving way for the prophecy of his return) was possibly from their perspective ill-timed and forced Karenac's hand.
And a last pointer... Pelor the burning hate.