When you open the ZIP archive you should see three folders:
Talent Guide (don't need this, the guides are pretty useless IMO as well)
Zygor_Alliance_InGame_Guide
Zygor_Horde_InGame_Guide
Zygor_Nether_Drake_Mount_Guide (this has a PDF file in it, not needed for the addon to work)
Zygor_Alliance_InGame_Guide and Zygor_Horde_InGame_Guide - these are the folders you want. IN those directories will be the folders you need to put into your /Interface/Addons/ folder.
The _InGame_Guide folders have the Addon folders in them. Just click and drag them to your WoW Addons directory (not the InGame folders, the folders inside the InGame ones). Both of the folders should have Cartographer and ZygorGuidesViewer in it, you NEED those folders as they're dependencies (addons the guide needs to work).
The other folders which are named: ZygorGuidesAlliance and ZygorGuidesHorde also go into the Addon folder. Either both or just one, depending on what faction you prefer.
Hope that helped!
Also Taiin, I totally agree with you. I started using the guide and it's bloody pointless. I personally use CARBONITE to track my quests. Like you said, all it does is tell you what quests to do and how to do them. It just skips the whole process of repairing items, buying near gear and buying professions and skills. Not very helpful.