First of all not a homework question, but one day it suddenly popped into my head while opening a bottle of soda and accidentally leaving a glass out for a while. I get that $\ce{CO2}$ in water is not the same as Carbonic acid, however this also raises the question if $\ce{CO2}$ can combine with water (It does so in acid rain in the atmosphere(I would guess normal temperature and pressure)), then shouldn't dissolved $\ce{CO2}$ just form carbonic acid and hence become unusable for aquatic plants? And also if Carbonic acid does form in the atmosphere ( Again,I would guess normal temperature and pressure (feel free to correct me!)), why does the fizzing happen in soda bottles when opened in the first place, should Carbonic acid be stable at normal conditions?
Please do note that I talk about $\ce{CO2}$ dissolving under normal temperature and pressure
I feel like I'm missing something super basic and obvious here and I just can't put a finger on it. Thanks in advance!