Little lagoon is great. Plenty deep enough once you get in a few hundred metres. Awesome flat water fun in southerly winds. The other spots in the gulf are a tad shallow and prone to having lots of seagrass.
I'd recommend wearing a pair of booties in the lagoon the shallow bottom can be quite abrasive on the feet. I was last up there in 2020. We were the only ones on the water.