A .zip file is just a container. Before your game can see the content, you need to "unzip" it.

Library \ Application Support \ Aspyr \ The Sims 2 \ Downloads

Note: If you don't see a Downloads folder, you can simply create one yourself. 3. Organization is Key