Hmm this is interesting. I would assume the tides would rise/ fall just as normal, but if you were standing on ground during low tide it wouldn't work because where you're standing would be water in high tide...
So I think you have to exit in order for the shoal cave's tides to change...