A Cork politician says people no longer have confidence in the Bishop of Cloyne's position following the publication of a report which showed that child sex abuse claims in the diocese weren't handled properly.