A Church of Ireland bishop has strongly criticised a Cork pastor who said homosexuality is a sexual sin, like rape and adultery.