"Not sure what a cold basement has to do with it? You suck in air from outside, extract the energy, and blow out colder air."
The water heaters I saw were not running ducts to the outside, they use the room air. The point is that heat pump efficiency is tied to the ambient temperature. The hotter the air, the easier it is to collect the heat from it. So when it gets cold enough the "emergency" or "auxiliary" heating coil starts to be used (resistance based). This is very common in cold climates. My house heat pump auxiliary tends to kick in when the tempature gets below 40. This would also apply to water heaters if using outside air than the warmer basement air. Of course you are heating that basement air with another source, so that efficiency should be evaluated too (likely a heat pump because if you have a gas furnace, one would be likely to have a gas water heater too).
"It's not controlled by any cloud. You can regulate on the control panel how and when you want it to run and it adapts with the weather too if you want."
The proposal in the article is that smart water heaters could be controlled by the utility companies.
"It is then used for heating the house via radiators as well as for warm tap/shower water."
That is one type of system. The article is talking the US, in which the type of system you describe is relatively rare. The 10 million annual water heaters they reference are overwhelmingly used just for tap/shower water.