Secret adult male and female sexual relationships with priests have left some with 'horrendous' consequences