The victim to abuser cycle is real, but no, that is not what repetition compulsion is. Repetition compulsion is the idea reenacting or reliving (in dreams or conscious thought) past traumas still as the victim (one of the key concepts is seemingly paradoxical behavior that increases the risk of being victimized again). It's outdated terminology from psychology circa literally a century ago - 'repetition compulsion' today would probably be considered a sub-symptom of PTSD, and it does not imply becoming a perpetrator as you are suggesting.
My understanding of the current consensus on the victim to abuser cycle is that abuse trauma is often correlated with poor social and emotional development of the abused, and those are about the closest things to causative factors for later abusive behavior that we know of. People abused by individuals they weren't raised by and growing up in a non-abusive home aren't nearly as prone to becoming abusers as those raised by their abusers... and unfortunately, a lot of abuse victims are victims of their own parental figures.
It's certainly not just repeating things with inverted roles, which is actually why Freud paid attention to it in the first place - it didn't involve reversing the roles, so it didn't fit with the theory of the 'pleasure principle' (it did the opposite), and he concluded that a desire to relive scenarios as they were, despite the possibility of reliving being victimized, was more basal than the pleasure principle because it seemed to override it.
Use of terms from that era like 'repetition compulsion' often fell out of favor because they were too foundationally tied to discredited ideas of the way psychology worked. Freud especially would build wildly speculative connections between ideas in his research to paint an inflexible (and incorrect) picture of psychology, and untangling that to reclaim a term like 'repetition compulsion' (when somethjng like 'PTSD flashback' gets most of the idea across without all that baggage) just wasn't worth the effort most of the time.
