If you click the link to the article about him saying it failed, he says:

Asked if the U.K. would have been better off remaining in the EU Farage insisted he didn’t “think that for a moment.”

So I think he's sticking to his guns that leaving was better than staying. The situation sucks for everyone in the UK :(