I have had airbrush makeup but did not use it at my recent wedding at Moon Palace. I would say that if your climate is going to be extremely humid-- airbrushing will be worth it. The humidity wasn't terrible this month in Cancun. My makeup was perfect all night. Had it done at 10:30 am, married at 4:00 and reception went until 10 pm. Jumped into the pool at 11 pm and my makeup was still perfect!!
I am not a super sweater either. It all depends on you and what you're looking for. Some women like it because they will spray your neck and collar bone area to blend a lot.
I use MAC products and so did my resort. They used a heavy primer and then use a setting spray at the end to make the makeup last. I would check with your resort to see what they use, check the average humidity and temperature and go from there.
Wishing you luck and a beautiful wedding!!