
A damp squib
British Origin
The phrase is more common in British English than American English, where it might be less recognized. 
Use in Disappointment
Use when describing events, projects, or plans that are less exciting or successful than expected. 
Metaphorical Use
It's often used metaphorically and not taken literally, referring to the 'fizzle out' aspect of an expectation. 