If that is the general consensus, it is wrong...
This is totally general, but most microalgae cannot use nitrate directly, but instead get their nitrogen from ammonia or ammonium, aminos or assimilating bacteria through their slime coat. Some hosts can convert nitrate for microalgae to use, but it costs them energy sometimes in the range of 30-60%... not great for the coral. Some hosts can recycle nitrogen of dead/decaying/releasing symbionts to be reused meaning that you only need new nitrogen for growth and not so much maintenance (this is not 100% true in all cases, but let's go with it to keep it simple).
Macroalgae can use nitrate directly. Chaeto, hair, etc. Most can also use ammonia/ammonium.
Both can also get nitrogen from amino acids and/or bacteria if they can catch and assimilate them - the ability to do this depends from coral to coral and algae to algae. Anything with a slime coat can do it if they can catch, but the lose a math game with so little surface area compared to the rest of the tank, especially while small. This is not known to be effective in captivity as it is in the ocean where bacteria levels are 50x and even amino supplements are often incomplete if they even list what aminos you are adding (not all of them are the same).
Microalgae that ammonia/ammonium can reduce nitrate on the back end since this does not enter the nitrogen cycle any further. However, I doubt that they are good source for doing so.
The best way to control or remove nitrate is with anoxic bacteria that use the oxygen in the no3 and turn it into nitrogen gas. Once you understand that corals don't really use nitrate, you see that the corals get from the front end and then bacteria can use the back end and grow to equilibrium. Deeper places in the sand and established rock (not so much dry/dead rock, at least for a few years) are very good at this. These places with no oxygen can get the nitrate down to levels that you need ICP to test at about .1 or .2. This is the last step in the nitrogen cycle that most people do not even know exist.