The Bloomberg Big Gulp ban idea was the worst of all options for paternalistic public health policy. It was maximally paternalistic, since it straight up took away the choice to buy a huge soda, and it wasn’t even going to bring in money for useful public services.
There’s some disagreement among researchers as to how much soda taxes depress soda consumption, but that’s fine because the main reason to tax soda is to get the money. Ideally it would get spent on public health programs, but it doesn’t have to. The broader point is that it’s a less-bad thing to tax than useful stuff like work and investment.