I think the reason some people might believe this claim is because we’re taught in school that the moon’s gravity causes the tides. I think the reasoning goes, “well if the moon’s gravity can affect the tides, surely it can affect smaller things too”
This is why they only change during a full moon; less moonlight than that is not enough to catalyze the reaction.