Families were forced to "run for their lives" after a firework shot into a crowd of onlookers at Eardiston Country Club.