A former footballer once scored a thunderous free-kick against Manchester United before a dramatic career shift