A light drizzle is best as it keeps the ground moist and therefore decreases the chance of a fire starting. Heavy rain can be very bad for a fireworks show as it could lead to the fuses of the fireworks becoming wet and consequently unable to launch.