Check this out! Here is a NASA aerial photo of Waikiki. Look carefully 'cause you can see where 'Apuakehau still flows out into the ocean through the movement of the sand.

As long as there is rain, the water will flow.