By his own admission, Roger Moore was, despite the title of the 60s TV series that made him a household name around the world, no saint.