The Archbishop of Canterbury has apologised after suggesting failure to act on climate change could be worse than the inaction of world leaders in the face of Nazi atrocities against the Jews.