Question: how to open zxp file?
Answer: Rename your . zxp extension file to use . ... 
Unzip the file, you should get a folder. Rename it if desired (You may need a 3rd party utility to unzip)
Copy that folder into ~/Library/Application Support/Adobe/CEP/extensions.
Restart After Effects.
Your extension should now show up under Window > Extensions.