NotWorthy, that’s exactly my take also. There are several examples of sexual sins in Genesis that come back to haunt Israel, this example being the most obvious.
Aside from this instance, probably the other most obvious one is Abraham having a child with Hagar, which he was not supposed to do. Abraham and Sarah were supposed to trust God; instead, they laughed when he told them about Isaac (the name Isaac means ‘laughter’). The child Ishmael is the branch by which Islam traces back to Abraham. Incidentally, this is also why we view God as ‘Father’ and the Muslims view God as ‘Master’. Isaac was the son of Abraham’s main wife Sarah, while Ishmael was the son of the concubine Hagar (children of concubines were slaves to the paternal leader of the family).
Also, Rueben was the oldest of Jacob’s 12 children and, as such, would have been the one to receive his Father’s blessing. When he slept with a prostitute, he forfeited the blessing. Likewise, Simeon and Levi forfeited the blessing when they deceitfully killed the Sichemites in retaliation for the rape of Dinah (Genesis 33). Thus, the blessing went to the 4th oldest, Judah, which is why Jesus came from the line of Judah and not Rueben, Simeon, or Levi.
I remember Scott Hahn saying that there were 6 sexual sins in Genesis that affected Israel in the future, but I could only remember these 4.