What is the effect of fizz on soda?

There is absolutely no relation between the amount of sugar in softdrinks and carbonation. Softdrinks, unlike brewed alcoholic beverages, are all artificially carbonated.

Sugar is part of the natural carbonation process; yeast eats sugar and produces CO2 and alcohol as by products.