The Installer is pretty self-explanatory. It just installs the program. The .zip download is more portable and allows you to run the program without installing it. It's good for using Blender on removable drives on different computers.

It is better to do one thing well, than to do many things and excel at nothing.