The 50-year-old says he is as proud to have been knighted for his charity work as he is his footballing feats