But sweet, carbonated beverages (on the shelf; the refrigerated bottles are kinda expensive) are one of the last, somewhat inexpensive products in supermarkets.
That's exactly the problem it's intended to address. It's cheap to buy, and expensive in its consequences.
I've seen it proposed that revenue from such a tax be used to subsidise fresh food, so that's another option that would double the nudge towards healthier options while being hip-pocket-neutral for shoppers (the devil is always in the detail, of course).