The house I live in has an existing oil-based boiler for both heat and hot water. The hot water tank (50 gallons) will likely need to be replaced in the next few years as it is more than 10 years old, probably approaching 15. I am on well water without a water softener, and I assume that the previous owners never did any sort of maintenance with the current hot water tank. (A neighbor mentioned that there is some sacrificial part that can be replaced every so often to extend the life of the tank.)
I keep reading that the hybrid heat pump water heaters are incredibly efficient, and I hate having to burn oil during the warmer months just to heat my showers. My plumber tells me that it’s a really efficient system and that I should keep it intact as long as I can. He also seems a bit old school in his opinion and preferences, as he scoffs at the idea that I would eventually like to replace the whole boiler and system with a heat pump system instead.
Is there a good place to learn about how my existing system works, and any way to compare to possible savings (or pitfalls) of switching to a new system? Are there other options, such as tankless hot water heaters, that I should consider? I gather that recovery time with a hybrid heat pump water heater will be much slower than the existing system, so should I also calculate for a larger system (65 or 80 gallons)? Two adults live here full time but we frequently host guests and family gatherings, and we sometimes need enough hot water for 10 or so adults to shower. There are three full bathrooms in the house and one day we may add a fourth.

Pitfalls:
You have a small space: heatpumps need airspace and it needs to circulate. An enclosed closet won’t work.
Your heater is outside: heatpumps pull air through and dust/cobweb buildup isn’t good.
You dont have electricity to the heater: heatpumps need a decent cuirruit size to run. Some can run off a small 120v circuit.
You didn’t size right: heatpumps can’t keep up with sustained demand usage. A larger tank offsets this.
You can keep your old system too though. Just put your hybrid before it and set your temps at like 125 for the heat pump and 120 for the boiler. Your boiler will rarely need to run unless you have sustained usage, a power failure, or it needs to bring temps up in the water it’s holding.
Heatpumps can have an external element to exchange heat.
I haven’t seen a water heater with one though.
The eternal plate can get frost on it in the middle of summer.
Here’s a This Old House video explaining the system and why it is better for colder climates.