I have a CO₂ heat pump hot water system (integrated by this Australian mob - https://reclaimenergy.com.au/ - but I think the heat pump unit is an OEM Japanese one) and it uses a ridiculously small amount of energy compared to my old conventional electric system (somewhere between 1.2 and 2kWh typically vs 4 to over 6kWh per day - and the new system also has a tank 2.5 times bigger than the small one I had before, which is so much better, and I probably use some more hot water than I did previously since it’s available). I have solar and it’s timed so it basically always is entirely, or almost entirely powered from that, so it’s gone from using more power from the grid than the rest of my usage combined, to now using almost no power from the grid.
Yes, it was a bit pricy but should only take a few years to pay back.