I retract my statement. I think the info I got (from someone translating the Japanese version before an English version existed) was mistranslated. I just checked my English copy, and it merely says that the hero will one day return to the ranks of the knights.
Man, that's a bummer.
1: an onscreen death does occur. In OoT, if, instead of going to open the door of time, you go in the alleyway, a soldier has his final words with Link, and Navi verbally shoes Link away from the scene because he is still just a child at the end of the day. I don't blame you for missing this...