You mean the scarey clown pool?
We stayed there last September and the kids, DS (8) and DD (3) loved it. The pool water was kind of chilly though even though the temps were 90 + everyday.
The slide is made to look like a roller coaster and its 200 feet long. DS loved it and so did DD. She was able to ride it with a life jacket. The pool is not zero depth, it starts at 3 feet I believe, but there is a kiddie pool also.
The pool wasn't too crowded when we were there. Plenty of seats by the pool also.