We were down there once during Gay Days and had a wonderful time. Now that I have kids, I wouldn't worry about taking them at all. I see it as a wonderful opportunity to teach your kids that people come in all types. And kids are more sophisticated than we adults sometimes give them credit for. When my five-year old asked, I told him most ladies marry men and most men marry ladies, but some men prefer to marry men and some ladies prefer to marry ladies and that it's unconstitutional to deny them that right.
Okay, I probably didn't need to add that last part.
Anyway, as the previous poster said, I didn't see anything you wouldn't see anywhere else. Now the humidity, that was another thing altogether.
Good luck. Have a lovely vacation.