My kids love it
Ocean Breeze Waterpark is a fun place to spend a day. Locals will get a season pass because the one-day price is somewhat hefty. As a local, I feel very safe letting my pre-teens go off together to ride the rides, but I keep my younger elementary age kids nearby. This is not a huge place like Water Country USA in Williamsburg, so it's easier to keep tabs on family groups.
The lifeguards, usually local teens, are quite professional and have eyes like hawks.
My kids love the water slides and wave pool, (and of course the concession stands--quite pricey). Definitely bring water shoes--the concrete can get hot. Get there early to get your lounge chair places staked out. Definitely use the lockers.