Australia's most senior Catholic does not believe a royal commission is needed into charge sex abuse perpetrated by members of the church in NSW.