The Legend of Zelda's saddest storyline highlights one of the bittersweet cores of the long-running Nintendo franchise.