I thought the Final Battle and ending was brilliant.
It intentionally brings up a lot of open-ended questions (personally, I agree with the 2 Dimension Adult and Child Link OoT theory).
That's what great about Zelda games, the whole Legend aspect. This can go on forever and they can continue to tell the great story of the Triforce in many, many differnt ways. The components of Wisdom, Power, and Courage are things that will always be at odds with each other, and therefore, there hopefully will always be new Zelda games!