I haven't even brought up psychoanalysis, and the idea of repression isn't confined to or exclusive to psychoanalysis. I even gave you a link showing it's even used in cognitive psychology, and, of course, cognitive-behavioral models are the current dominant models utilized in psychology.
It isn't used in cognitive psychology in any sense that relates to your posts; your brought up psychoanalysis by referring to a concept that was developed entirely within psychoanalysis; you provided a link that discussed repression in terms of Freudian psychoanalysis (which included a section on how this notion fails in certain senses in cognitive psychology) ; your link gave a description of repression that is irrelevant here, as "motivated forgetting", according to your source, is unsupported and the entirety of repression is at best described within cognitive psychology literature as "simply forgetting something...unpleasant" ("The proposition of motivated forgetting, where the motivation is both unconscious and aversive, has never been demonstrated in controlled research. For the cognitive psychologist, repression is simply forgetting something that is unpleasant. Thus studies have been done where experimenters are nasty (vs nice) to people who are trying to learn things and later it was demonstrated they remembered less when the experience was negative as opposed to positive").
In short, you claimed that an unscientific, armchair psychoanalytic notion (repression) has been empirically shown to cause "harm" in ways that could only be defined into existence via methods that lack even the sort of rigor and validity used in parapsychology studies and similar nonsense, and then linked to some popular source in which "repression" was defined first and foremost via Freudian psychoanalysis and then how this conceptualization utterly fails to find empirical support and to the extent it exists within cognitive psychology literature it is simply a memory issue.
You have not demonstrated that there even exists anything remotely like the evidence for e.g., the harmful psychological effects of promiscuity, pornography, etc., as there exists for celibacy. You haven't really even demonstrated that said research exists in any form whatsoever beyond perhaps a few non-scholarly sources and some vague, isolated (limited) studies.
You have instead relied on components of non-scientific, outdated psychoanalytic theory, linked to an article on Freudian psychoanalytic theory which describes how this component of psychoanalytic theory (Freudian or post-Freudian) empirically fails and isn't used in cognitive psychology, and then claimed that your link shows how repression is somehow relevant in actual cognitive psychology.
Real scientific literature on memory is so vastly more complicated and so far beyond simplistic nonsense like "repression" that
entire types of memory have proliferated into the hundreds and it is difficult to demarcate via behavioral or neuroscientific experiments what the nature of which kinds of memories is. To argue that celibacy is psychologically harmful because of some kind of repression brings us back before even behaviorism, all the way back to penis envy and other bunk proliferated long before it would have been possible for either modern psychiatry or cognitive psychology to exist in order to describe the harms of celibacy.