There was always a difference of opinion within the psychiatric community. No less than Freud thought homosexuality is normal, though later "Freudians" thought otherwise.
This has no bearing one way or the other on "gay rights", or priestly misbehavior.
Freud called it perversion until he coined his own terminology and called it inversion. Regardless he held it as pathology.