Carbonated water is very mildly acidic.
Sodas (the sweetened ones), which I’m guessing are what GP is mostly referring to (what with the mention of sugar earlier in the paragraph) have sugar, which may encourage the growth of bacteria that are detrimental to teeth; and some of the flavorings are more acidic or react chemically with enamel to dissolve it.