"The fallen leaves tell a story"
Shows Marika shattering the elden ring, the next scene is alraedy Radagon trying to mend the ring. This foreshadow a later revelation, Marika and Radagon are one.
"The great Elden Ring was shattered."
"In our home, across the fog, the Lands Between"
Where is across the fog? Why is it called the Lands Between? We know the tarnished were banned from these lands and left it by boat it maybe a central continent only accessible by those touched by grace so the fog may act as some kind of gate like the fog gates we traverse to reach a boss room.
"Now, Queen Marika the Eternal is nowhere to be found..."
Shows Marika in position similar to her statues inside the churches dedicated to her. It's already possible to notice some cracks in her body. When you find her inside the Erdtree she's only being held complete by the rune.
"...and in the Night of the Black Knives, Godwyn the Golden was the first to perish"
It shows the the assassins killing Godwyn, they used Black Knife, going by the item description it was imbued with the power of Rune of Death, this rune was stolen previously. All the assassins in the Black Knive group are women as it appears in their armor description. Still according to the set descriptions, they were all Numen (race of humanoids whose Marika is also said to be one) and had close ties to Marika.
"Soon, Marika's offspring, demigods all, claimed the shards of the Elden Ring."
At this moment it shows a Ranni image, doing her quest we discover that she was also killed almost at the same time as Godwyn and her physical death was her plan all along, as she wanted to ditch her body so her soul was transfered to the a doll.
While the narration is still going for that phrase an image despicting Margit fighting against Radhan.
The mad taint of their newfound strenght triggered the Shattering
The image there despicts Mohg abducting Miquella, we can notice Miquella's cocoon behind Mohg. Examining Mohg's robe describe him both as a Luminary and a raving lunatic, his spear serves as a form of communion with an outer god called Formless Mother.
We end discovering that Mohg abducted Miquella because he wanted to create a new dinasty with Miquella being the head of dinasty and him being his consort.
The second imagem shows Rykard being eaten by a serpent, later when fighting him we discover that he was the serpent and is consuming people to be powerful enough to consume the gods.
"A war from which no lord arose. A war leading to abandonment by the Greater Will."
"Arise now, ye Tarnished. Ye dead, who yet live. The call of long-lost grace speaks to us all"
At this moment some images show a mausoleum/crypt with a lot of dead bodies, some kind of priest must be seeking some tarnished who were brought back to life.
From now on important tarnished will be show:
"Hoarah Loux, chieftain of the badlands."
We discover that he was the first tarnished, being previously Godfrey the first Elden Lord and Marika's first consort. The first time you fight Godfrey you're fighting just an illusion with him being in his prime. After burning the Erdtree and going through the Farum Azula, Godfrey/Hoarah Loux can be fought right before the Erdtree entrance. So far I did not find a reason why he was banished
"The ever-brilliant Goldmask"
There isn't much about Goldmask in the game, he's part of Cohryn quest. Goldmask will be killed by Cohryn once help him discovering that Marika and Radagon are one. If the quest is completed he produces a rune that you can use to mend the Elden Ring.
"Fia, the Deathbed Companion"
Fia is an interesting character, initially she says that some circunstances made her stay at the Roundtable Hold, letting her hold you grant a -5% debuff to your health that can be removed by using a blessing that boost your poise for some seconds. When talking to her she says that she used to receive the warmth of champions and she could lay with a dead noble so they could live again. In short she has an ability to steal life from whoever lays with her. Progressing her quest we discover that she is the companion of Godwyn, Prince of Death. At the end she also produces a rune that can be used to mend the Elden Ring.
"The loathsome Dung Eater"
There isn't much about Dung Eater, during the opening cinematic it shows him being hanged so we can guess he has been an asshole for a long time. Interesting to note that the room where he appears as a red spirit has a lot of dead bodies there, when finding him in the sewers he is slamming his head against the wall. His quest involves you defeating him after he kills a NPC and implanting his curses in his body, this thing must hurt because he screams a lot everytime you do it, by the ending of his quest he also produces a rune to mend the Elden Ring.
"And Sir Gideon Ofnir, the All-knowing. A tarnished of no renown"
He is shown to be lying in a coffin and is covered in ears and has a box with eyes. He only talks to you after getting a great rune, and I'm almost 100% sure that he's the one responsible to send the assassin to kill you. He's also the only other tarnished in the Roundtable Hold that doesn't create a rune upon the ending of his quest. Talking about his quest he seemed interesting in becoming the Elden Lord or "helping" you became but later changes his opinion and try to stop you.
"And one other. Whom grace would again bless. Cross the fog to the lands between to stand before the Elden Ring and become the Elden Lord."
This is our character, appears to be in an empty place and dead being revived by the grace and describing what is our initial objective. When reaching the Erdtree for the first time, we discover that it rejected us and upon returning to the Roundtable Hold the Two Fingers is trying to contact the Greater Will but it will take a millenia to have the answer.