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”
Sleep disturbances around full moon could be easily explained by the appearance of a bright light in the night sky. Easily tested too - what happens if you use blackout curtains?