Club legend had taken on high-performance advisor role while supporting his wife’s battle with cancer