The chart shows what form the energy takes after being used (transformed) by the device.
Notice that the LEDs actually produce more RAW heat than MH or FL (in the form of conduction and convection). The heat is carried away via the LED die and/or attached heatsink.
Notice the the Incandescent bulb produces more RADIANT heat than any of the others.
Anyway back to your basic question. Energy is Heat. When that light is absorbed by the mass around it, it turns to heat. Now some of it may cause a chemical reaction (photsynthesis) that in turn adds biomass to the tank. But rest assured when that biomass dies, it will release the heat

Again this is a very small percentage anway and not really worth talking about esp in the context of a few watts of LED light.
So you need to rethink your understanding of "pure heat". Stand in front of a sun filled window and feel the warmth on your skin. The light is striking your skin and being transformed into heat.
Yes, your are correct a few LEDS in your fish tank are not going to be a problem. The point was that if you put 20W worht of LEDs into the tank, you should expect somewhere close to 20W worth of heating. As shown by the table above 85%-90% of the energy consumed by the LED is transformed directly to (to use your terminology)
PURE HEAT and will be siphoned off by convection and conduction into the tank. That leaves 10%-15% that is leftover for light. Out of that 10%-15% only a fraction of the energy will leave the tank or be used for photsynthesis, the rest will be absorbed as heat by the mass of the tank.