The former Liverpool defender became a hero after the Reds won the European Cup in astonishing fashion back in 2005