The former footballer has opened up on the health condition he kept hidden throughout his playing career