With a harrowing finale that has left viewers rocked by Clarkson’s health news, the Prime hit has gone beyond cute pigs and wet weather to plumb new depths, writes Ellie Harrison