The response to child sex abuse allegations was totally inadequate and ineffective, the former head of the Catholic Church in Ireland has said.