I unfortunately have never been (its always on a week day).

I think you can get pretty close to the planes on the ground (e.g. 10-20 meters for the military ones before hitting the ropes).

Technically the general public are not allowed entry, but I think as long as you give any kind of business card you can visit.

In terms of plane aerobatics though, the Al Ain show down the road is better:
http://www.alainaerobaticshow.com/