I feel much the same way.
If I lived in the UK, or if the US ever adopted UK-style pistol laws, I'd collect obsolete caliber pieces.
But I do own a few modern cartridge pistols that I could never part with, because of sentimental reasons. As they have no historical value, those I would keep, and have deactivated.
I'd rather have them deactivated, and still have them, than see them completely destroyed.
Jim