Let's just clear up some inaccuracies. There's no such thing as a "negative dipole". A dipole is the separation of positive and negative charge. CO2 has two dipoles equal in magnitude and opposite in direction, so the molecule overall has no dipole moment. But you are right that the charge distribution is non-uniform, although the symmetry of the distribution means there is no molecular dipole. The O atoms have a negative partial charge (not "dipole") and the C has a positive partial charge (not "dipole"). Each C=O bond is polar, but as you say, in the molecule as a whole the two dipoles cancel out. At distance, as in a gas, the molecule appears non-polar (there are quadrupole-quadrupole interactions, but they are much weaker than dipole-dipole), but at close quarters the local polarity of portions of the molecule becomes significant. Presumably that's how water reacts with dissolved CO2 to give H2CO3 - the O of the water is attracted to the C of CO2.