Former UKIP leader Nigel Farage, who once vowed to leave the country if Brexit turned out to be a disaster, has stated: "Brexit has failed."