Archbishop Stefan Hesse of Hamburg, 54, offered his resignation after the publication of a report on his handling of abuse in the Archdiocese of Cologne.