People should not waste time waiting for "larger-than-life" heroes to bring solutions, the Archbishop of Canterbury has said.