Cook county tried it in Illinois a few years back, and it really made no sense.
It didn’t apply to juices (even though juices are loaded with sugar) and it taxed sugar free sodas the same as their sugar sweetened versions. They charged 1 cent per ounce for the tax. It was repealed 4 months after initiating it.
Plenty have been fighting for it, but there’s an uphill battle against “but that’s socialism and socialism is evil!” and those that personally benefit financially who stand in the way.