I think Zelda U should have a story, but it should, like Soul said, go with the open-world gameplay rather than interrupt the player.
For this game, I think it's best that the story has minimal cutscenes and most of the storytelling should be details you discover rather than contrived story bits.