The legendary Olympic cyclist was told he had terminal cancer shortly before his wife received her own crushing diagnosis