A top cleric in Germany's Catholic Church has offered to resign as the Archbishop of Munich, saying he shared "responsibility for the catastrophe of sexual abuse" by church officials.