With president Herzog by his side, Steinmeier laments litany of failings that led to massacre of 11 Israeli athletes at 1972 Olympics; Herzog voices hope compensation agreement would bring ‘this painful episode to a place of healing’