Carbon dioxide is dissolved in water to lower the pH. Plants and algae are supplied with carbon. This method is particularly widespread in the freshwater sector. In marine water, carbon dioxide fertilization is used only in special cases.
There are different ways to get the carbon dioxide (CO2) into the water:
Total hardness / Alkalinity / Magnesium / KH / Acid capacity - an overview: https://www.aquacare.de/index.php/en/aquaristic/aquaristic-info/hints-tricks/50-water-chemistry-physics/250-hardness-overview.html