Alastair Campbell says that Brexit has led to Britain becoming known as a "global joke" and that there is a lack of leadership across the political spectrum on the issue.