Here are the Gulf Shores parks:
http://www.rvparkreviews.com/regions/alabama/gulf-shoresWe always stay at the state park so can't help out. There are paddling bayous in the area, also. There's a day trip small ferry ride. Google for other activities. You'll find lots.
I'm sure you can find kid-friendly things in New Orleans but it just doesn't strike me as family-wholesome as Gulf Shores. Perhaps if you stay out of the French Quarter it would be better. Yes, you see all kinds in New Orleans just like Vegas. Some may disagree.