>>715502590
>abandoned all his other plans because they failed
No, this is a complete fabrication. Some poorly showhorned headcanon spread through Reddit that only contributes to further misconceptions.
Miquella's only failure is stated in game as the inability to revive a Soulless Demigod body to life, Ensha's body, to accept Radahn's soul.
Miquella had created a Carian sword of Amber to bestow to him but the Ritual of the Church of the Eclipse failed.

Ensha of the Royal Remains is a nightfolk (like the silver tears found in the path of the Haligtree), dressed in corroded golden bones and protecting the Haligtree by spying on the Roundtable Hold.

The Haligtree was never a failure and is nowhere stated to be a failure. It's the process to create a Lord that failed.

That's the same thing the scions of the Eternal City want. They killed Godwyn with the prospect of his revival making him Lord of Night because a Lord and a God can only become one through rebirth.

Radahn becomes the Starscourge exactly because Demigods have their fated Death removed and he wants to die. The festival itself his Radahn's personal failsafe.

Elden Ring anticipated the Sacred Rite Scroll

>>714399869
No, Radahn is Promised Consort because the narrative was built with the idea of him resurrecting as the Consort.

Miquella's only failure was not successfully killing Godwyn, since only one Demigod Lord of Those Lost in Death can exist, and Castle Sol can't prepare the vessel