Judging from how hard it can be to sleep during a full moon while camping, I'd say the reason humans aren't generally affected by it is because they sleep underneath opaque shelters that block direct light.