Túrin and The Second Prophecy of Mandos

[Maedhros]

Would Túrin really return from the dead and kill Morgoth? This prophecy has long roots. From The Book of Lost Tales II: Turambar and the Foalókë

Then Úrin departed, but would not touch the gold, and stricken in years he reached Hisilómë and died among Men, but his words living after him bred estrangement between Elves and Men. Yet it is said that when he was dead his shade fared into the woods seeking Mavwin, and long those twain haunted the woods about the fall of Silver Bowl bewailing their children. But the Elves of Kôr have told, and they know, that at last Úrin and Mavwin fared to Mandos, and Nienóri was not there nor Túrin their son. Turambar indeed had followed Nienóri along the black pathways to the doors of Fui, but Fui would not open to them, neither would Vefántur. Yet now the prayers of Úrin and Mavwin came even to Manwë, and the Gods had mercy on their unhappy fate, so that those twain Túrin and Nienóri entered into Fôs'Almir, the bath of flame, even as Urwendi and her maidens had done in ages past before the first rising of the Sun, and so were all their sorrows and stains washed away, and they dwelt as shining Valar among the blessed ones, and now the love of that brother and sister is very fair; but Turambar indeed shall stand beside Fionwë in the Great Wrack, and Melko and his drakes shall curse the sword of Mormakil.'

Then it changed again in the Sketch of the Mythology or 'earliest Silmarillion'.
From The Shaping of Middle-Earth: The Earliest Silmarillion

When the world is much older, and the Gods weary, Morgoth will come back through the Door, and the last battle of all will be fought. Fionwë will fight Morgoth on the plain of Valinor, and the spirit of Túrin shall be beside him; it shall be Túrin who with his black sword will slay Morgoth, and thus the children of Húrin shall be avenged.

Now we go to The Quenta. From The Shaping of Middle-Earth: The Quenta

Thus spake the prophecy of Mandos, which he declared in Valmar at the judgement of the Gods, and the rumour of it was whispered among all the Elves of the West: when the world is old and the Powers grow weary, then Morgoth shall come back through the Door out of the Timeless Night; and he shall destroy the Sun and the Moon, but Eärendel shall come upon him as a white flame and drive him from the airs. Then shall the last battle be gathered on the fields of Valinor. In that day Tulkas shall strive with Melko, and on his right shall stand Fionwë and on his left Túrin Turambar, son of Húrin, Conqueror of Fate,7 and it shall be the black sword of Túrin that deals unto Melko his death and final end; and so shall the children of Húrin and all Men be avenged.

7. Added here in pencil: coming from the halls of Mandos.
We have also a Commentary regarding this part. From The Shaping of Middle-Earth: Commentary on the Quenta

The appearance of Túrin at the end remains profoundly mysterious; and here it is said that the prophecy names him among the Gods, which is clearly to be related to the passage in the old Tale of Turambar (II. 116), where it is said that Túrin and Nienor 'dwelt as shining Valar among the blessed ones', after they had passed through Fôs' Almir, the bath of flame. In changes to the text of Q II it is said that Túrin is named among 'the songs of the Gods', rather than among the Gods, and also that he comes 'from the halls of Mandos' to the final battle; about which I can say no more than that Túrin Turambar, though a mortal Man, did not go, as do the race of Men, to a fate beyond the world.

We have also a reference of Túrin returning in the Annals. From Morgoth’s Ring: The Annals of Aman

On the two star-makings see p. 61, §24. There is here the remarkable statement that Menelmakar (Orion) was 'a sign of Túrin Turambar, who should come into the world, and a foreshowing of the Last Battle that shall be at the end of Days.' This is a reference to the Second Prophecy of Mandos

Yet in the Later Quentas, the Menelmakar, had removed as a sign of Túrin Turambar.
From Morgoth’s Ring: Later Quentas

Here the two star-makings are expressly contrasted, and Varda's names Tintallë 'the Kindler' and Elentári 'Queen of the Stars' differentiated in their bearing. The second star-making is described also in AAm§§35 - 6 (p. 71), but far more briefly, and though the 'gathering together of the ancient stars' to form signs in the heavens is mentioned there also, only the constellations Menelmakar (Orion) and Valakirka are named. That Menelmakar forebodes the Last Battle is said in both sources, but LQ does not name it as a sign of Túrin Turambar.