What do you think makes carbonated and other soft drinks acidic

A VERY small part of the acidity is caused by the CO2 itself; i.e.,

CO2 + H2O ==> H2CO3 but a large part of the acidity is due to the presence of H3PO4 (phosphoric acid).