Ex-England star and pundit Wright cut a forlorn figure in an Instagram video two days before the tournament starts