Squid are indeed usually damp in their natural environment, but the popular British expression describing a less than spectacular explosion is a “damp squib” (soggy firecracker).