Close, but no cigar

Why is Neil trying to smoke a cigar in the studio? Learn an English expression about almost succeeding