All-Ireland primate Cardinal Sean Brady has welcomed the Vatican's response to the Cloyne Report and claimed it conveyed "profound abhorrence" for the abuse.