It makes it easier to share maps that include a lot of custom assets, like scripts, models, sounds. Basically it saves everything you could have changed, and packages it so you can send it to your team and they wont be missing objects because you forgot to save them individually.
No it wont make an .exe file.