Is this a good place for little kids? I have an almost 2 year old.

Yes , they have something for all ages, great fun!

Yes there is a waterpark jungle gym thing that is awesome for little ones

There is an area for younger kids and watching movies in the wave pool might be good, but probably won't enjoy the experience as much as a slightly older child. However, it might be a good start to a family tradition that gets better over time.