He revealed the news and parts of his health battle in the two final episodes of his Amazon series Clarkson’s Farm