A new WalletHub survey found two-thirds of Americans think local governments should not use taxpayer dollars for fireworks displays because of the tough economic times.