"When the next Elder Scroll is written, you shall be its scribe..."
I hope you all know this line, and lines like it, are pretty much Beth bending the 4th wall
Think of the Elder Scrolls as the game itself, and you, the scribe, the player outside the game making your character's choices.
There's a reason why the Elder Scrolls always play different events, leading to the same end, depending on the reader, it's because it's actually more like this:
The Elder Scrolls (the game) speak of an event (the MQ), and the hero (your character), whose actions differ depending on the reader (the player), fulfill the prophecy told by the scrolls (the end of the MQ).
Anyway, other than one wishing to continue their CoC, who was the Nerevarine previously, who was also the Eternal Champion and Septim's Agent, the CoC has been effectively written off by Beth with the SI expansion. All we'll get, at best, are vague rumors and such, like with the Nerevarine. Septim's Agent may have been the Blade that was stepped on by the Numidium, and the Eternal Champion's identity is effectively unknown, other than he saved the emperor Uriel from his battlemage, Jagar Tharn.