Brother, Morrocoy is a paradise. The park is made up of mangroves and several small islands known as keys. Since I had my children, there is one that we love because it does not have any waves, it is called Playuela. And answering your question, yes, the water is so clear and the sand is so white that you can see the fish without much effort. I love snorkeling there because it is the perfect place to see marine fauna.
However, there are keys for all tastes and almost none have significant waves.