For one CO2 is an acidic oxide, it reacts with water to produce a salt species. Also, "dissolve" is not equated with solubility. As long as a gas, such as CO2, has a partial pressure above water, it will run into the surface of the liquid (such as water) and in a sense dissolve. CO2 has a net dipole moment of zero, however water can still be attracted to it through other means than dipole-dipole interactions.
Help with chemistry