Yeah, it’s kind of a cyclical thing. Kronos was destined to be overthrown by his son so he ate him. Zeus is also destined to be overthrown by one of his sons and is a tyrant because of it. He can’t help but screwing everything he sees though, so his character flaw will eventually end him.

I think it’s a commentary about sex being power and power seeking being the eventual downfall of the powerful.