Russell Brand was exposed as a "messiah with feet of clay" in his Question Time clash with Nigel Farage, the Ukip leader has claimed.