I haven't been to too many of these shows, but it was pretty awesome.
I'd recommend you spring for the best seats you can get. They are pretty ridiculously expensive, but it is worth it. We sat in the third row and you can see a lot more detail regarding what is going on in the water. We had to make reservations a couple months in advance, but it was worth it.
I have no idea what the plot of the thing was - it was definitely artsy fartsy, which would have annoyed the hell out of me if the acrobats hadn't been awesome to watch.
And don't buy popcorn while you're watching the show. That makes you look like a tool.