A standard gas or electric water heater has very few parts and only a few that are prone to failure. Not counting the anode, which is a service item and should be changed every so many years (like tires). Conversely, the heat pump on a HPWH is a fiddly device which can fail for any number of reasons. If you can find a model designed so that the whole HP can be popped off and replaced, and the manufacturer lists the price of that replacement, and the installation does not require an HVAC tech, then at least you can estimate what it might cost to keep one of these running. My impression is that failures on most of these are like a failure on any other heat pump or A/C, where a trained technician with the right tools to safely (ecologically) pump out the coolant and recharge must be called, when anything in the loop needs service. $$$.
Personally I have been on the lookout for years for a combined house heat/pump A/C, water heater combination where the tank and the house side of the HVAC would fit in a small space inside the house. Because, of course, that is where our current gas furnace and water heater are located. Seems like a no brainer that if one has a heat pump outside that it should be able to direct the heat either to the "furnace" or the water tank, as needed. This would reduce the inside hot water tank to a dumb receptacle. No heating elements at all, and just a sensor for the logic located back at the HP. (It would still need the pressure release valve, of course, although it is very hard to imagine a failure which would result in it being employed.) AFAIK nobody makes anything like this. There are products to replace the furnace and A/C, but not also the water heater.
It looks like there is a company finally starting to make a product like that.
https://www.harvest-thermal.com/faq
Not going to bet my house's HVAC on a startup though. If Rheem, Carrier, etc. ever get to this point I'm in.