The head of the Catholic Church in Ireland, Cardinal Sean Brady, has vowed to stay on as he attempted to distance himself from a secret inquiry into one of the country's most dangerous paedophiles.