Some cyanobacteria can take up nitrogen from the air (well, dissolved inorganic nitrogen), but many can only use organic nitrogen, like N03 or NH4. Those can be limiting in the ocean because lots of life wants to grab it up.

Taking up inorganic nitrogen is called nitrogen fixation and takes a bunch of machinery and energy. Also, oxygen inhibits the process, so for photosynthetic bacteria a bunch of extra steps have to be taken to compartmentalize photosynthesis and nitrogen fixation. So not all cyanobacteria can do it, and even the ones who are able to will prefer to take up organic nitrogen if available, and they grow slower when they have to use N2.

Nitrogen is often the limiting factor for ALL plant growth, which is why it's the primary component of fertilizer.

Nitrogen in air is not normally available to organisms. The triple bond between the 2 nitrogen atoms is very strong and takes a good deal of energy to break. Some bacteria can do this, and legumes famously have evolved to house bacteria capable of fixing nitrogen in their roots.

The main way we get nitrogen to agricultural plants today is by the industrial production of ammonia, which takes enormous amounts of energy and lots of fossil fuels as presently implemented.

Not the GP and I do not have relevant scientific expertise, but my memory from beer is that CO2 stays dissolved longer than N2? Are they underwater?