The Catholic archbishop-elect of San Francisco has apologised for his arrest on suspicion of drunken driving, saying he brought “shame” and “disgrace” on himself and the church.