> the tides being caused by the moon

Mostly because people around the mediterranean sea didn't have to care, tides being so small there. Yet the Greek had fairly advanced models of tide schedules.

Pretty sure peoples that were experiencing bigger tides and depended on it e.g for fishing figured out the relationship with the moon pretty quickly, whatever esoteric reason they may have plastered upon it.