Storm Bert has damaged a Wiltshire light show visited by thousands, forcing it and its venue to close.