In fact, a Rutgers study found a net positive effect due to the tax spend on early childhood education. https://nieer.org/wp-content/uploads/2021/09/Beverage-Tax202...
Not sure what you think happened with property taxes, but there was no rash of store closings. Due to consumers periodically bulk buying soda at a different chain outlet or otherwise.