In his documentary 'Sir Chris Hoy: Cancer, Courage and Me', the Olympic cycling legend shared how he dismissed one key pain before his prostate cancer diagnosis