im geussing this is all of the ''covenants'' we see in game having theyre story continued, the burned erdtree is possibly being taken over by godwyns death root and miquella/St trinas eclipse has come aswell, im hoping its something to do with those two anyways

Miquella being Torrent's former master could have some lore-shattering, no just straight up plot-shattering implications. It might mean he worked together with Ranni, who orchestrated the death of his "dear brother," and maybe Melina as well. This would be something basically no one had speculated.

Did Miquella plan everything that transpired? Were we doing his bidding all along? Did he see Ranni as the only one capable of removing Outer Gods from the Lands Between? Was that why Malenia fought Radahn? What the hell is even going on in this game's story?

I guess we'll eventually find out. since I expect this expansion to be much more like Old Hunters than Ashes of Ariandel/The Ringed City, where it ties up remaining plot threads rather than introduce something completely new. By the same token, I also expect that we'll find out more about the first wave of Tarnished that returned to the Lands Between, like Vagram, Tragoth or Istvan.

Some really exciting stuff. And I think we'll have a lot of revelations that not many people expect. "Shadow of the Erdtree" certainly is mysterious enough of a title to warrant that hope, it sounds like something very insidious was hidden from us all along.

There should really be a good ending for the expansion. But knowing From, the world would probably be worse off at the end of the expansion lol.

My speculation , this is post erdtree burn , with miquella comeback of his slumber

Miquella is cool and all but I'm more excited to get more Godwyn lore/ a boss fight. As the first of Marika's kids he had to be important not to mention incredibly powerful.

Could the painting called "prophecy" have anything to do with this?

A tip for new fromsoftware players, start the dlc with your first playthrough if you haven't finished or create and strengthen a new character if you already have.
Playing DLCs on NG+ can be a difficult and frustrating in any Soulsborne game for any fan! I hope this saved some headaches.

I wonder what ending the dlc will be based/contingent on

Im hoping for more mounts-or at least giving torrent armor sets

Still waiting for Queen Marika's an updated autopsy report.