Water and co2 combine to make a weak acid. But that isn’t the acid that is the issue. The real issue is that soda makers like coke intentionally make the soda more acidic, to cover up the overly sweet. Without the added acid the soda would taste way too sweet.
The real issue tho is all the sugar they put in it. All the added calories and triglycerides is what kills you over time.