Collecting all of Link's memories lets you view a secret scene after the credits roll; however, the game still ends after that. When you reload, you'll respawn at the last point you saved before entering the final battle.