The normal process of gas exchange between a tank and the atmosphere will normally reach equilibrium. This doesn't mean the dissolved gasses in water are there in the same proportion a the atmosphere. Water can hold only so much of any gas and that level should be reached as long as there is sufficient surface agitation. When there is the gasses will move in the required direction to reach normal equilibrium. So if there is too little co2 in the water, agitation will allow more in, and the same applies in reverse.
Airstones and surface agitation will let out excess co2 but if a tank is below the normal concentration, it will let in co2. So it is when one is adding go2 to the water that minimizing surface agitation is a good idea. Typically, we only add co2 to planted tanks and then only when the plant load has such a high co2 demand that simple surface agitation cannot replace the co2 as rapidly as the plants can use it up. While some co2 addition will usually help any planted tank, even low light ones, it is usually only needed in higher light applications.
It is possible, by minimizing surface agitation in a planted tank, to raise the level of co2 in the water some, but not enough to meet higher level demands.
Most of the gas benefit of an airstone is due to the surface agitation the bubbles make. Another benefit is from the rising action of the bubbles which creates current that helps with circulation in a tank. And then, many folks like the look of the rising bubbles.