Speaking generally, yes, if they train themselves to self-regulate, let everyone around them know they are trying to control their compulsion, collaborate and cooperate with treatment providers and the authorities and see every day as a day of living a good life, which means thinking ahead, not testing themselves to see if they can resist, avoiding unsupervised children, staying out of the way of supervised children (so going to church when children are sat with parents is still not on), putting into action all the techniques they learn to dismiss unwanted thoughts and fantasies and stop kidding themselves that they don't do harm if they are kind. They might not learn to empathise with the people they have harmed - it doesn't marry up in their heads when thet believe they are 'nice' people so would never hurt anyone (except for sadistic sex offenders who rely on causing harm).
That's generalising - there are so many different individuals who need relapse prevention/self-regulation that is tailored individually to them. Not all sex offenders will offend again, treated or not. Some treated sex offenders will still offend again and will have learnt how to 'talk the talk' to try and convince others they are safe. It's not an illness and there isn't a cure, just self-control or control by the authorities if they can't control themselves. Risk assessment and management by the authorities tries to determine which ones need closer monitoring. Child protection police do a tremendous job, supported by the relevant agencies.