I am not 100% sure of these facts, but I read somewhere a while ago that chemical castration doesn’t stop the desire to act, but only the ability. People who are chemically castrated have the potential to carry out crimes of a far worse nature as a result.
I am sure there was a whole lot of stuff about this in a book by Ann Rice called Castrati. They used to castrate young men before their voices broke so that they could sing women’s parts in operas in Italy years ago. I can’t remember the specifics but I am sure that it didn’t prevent them from having sex, but it did cause them to end up completely screwed up and some of them were very very unpleasant as a result.