Yes, most CO2 stays CO2. however in most cases there is already bicarbonate in the aquarium water, and there is balance between carbonic acid, CO2, bicarbonate and carbonate depending on pH -value.
Its hard to explain in a language I don't master properly, but maybe this figure shows you what...