No question he had to resign.
The cables were almost certainly leaked by the Russia, to poison us-uk relations. The Daily Mail is a witting or unwitting tool of the Russians here.
But he was doing his job. And he was right. It’s what all ambassadors are telling their bosses back home.