The negative affects you mentioned are the result of the sugar and not the carbonation. So, replacing a soda with apple juice will have many of the same effects.

Non-carbonated high energy drinks can be as bad as the carbonated ones. It is the sugar and stimulants that have bad consequences.

Right before reading your post, I watched a video by Dr. Berg claiming that there might be health benefits to carbonated drinks. If you really like carbonated drinks you might find some brands like LaCroix or Izzies that have lower sugar.

It is also possible to make your own carbonated drinks. This allows you to control the sugar.

I am not sure about the health effects of beer. It can cause a beer belly and dizziness. But here is a beer none-the-less.

!BEER