(a) Carbon dioxide is the oxide of a non-metal, and non-metal oxides are acidic oxides. The hydrogen ions do not come from the carbon dioxide alone; it reacts with the water it is dissolved in to form carbonic acid, and that acid gives hydrogen ions in solution:
CO2(g)+H2O(l)→H2CO3(aq)
Carbonic acid is a weak acid, so the pH is only about 4, not 1 or 2. (The same acidic nature is why carbon dioxide reacts with a base such as lime water to give a salt and water.)
(b) The carbon dioxide was dissolved under pressure. Once the bottle is open, the gas slowly escapes as bubbles. As the dissolved carbon dioxide is lost, less carbonic acid is left, so there are fewer hydrogen ions per unit volume and the pH rises towards 7. The soda water is still slightly acidic after a night, because some carbon dioxide stays dissolved.
