I have a few safe queens that I'll never shoot or most likely will never shoot again.
I'll never shoot my late 1880's M&H pocket pistol because its an antique, locks up loose, and is unsafe to shoot with modern ammunition.
I'll never shoot my wartime ppk again, once was enough, and I have other ppk's to shoot.
I won't shoot a NIB chiefs special flat latch I bought because its the only NIB gun I have, and I like having an old NIB gun.
I don't shoot my Colt diamondback much because I fear timing issues, don't have the knowledge to fix it, and probably couldn't find the parts if I did.
I have enough guns to shoot that I don't feel I'm missing out on the few I don't.
Why do I have them?
In the case of the M&H, I just like to admire the action. Its a pretty unique approach.
The ppk is a piece of history that I came across in a pawnshop for a good price,
same for the chiefs special. I'll find another J frame if I want to shoot one.
The diamondback was a steal of a lifetime and will most likely be an investment or trade fodder at some point, and its worth much less either way if it breaks or goes out of time.
Guns are tools but they have other uses besides shooting.
Investment, collecting, interior decoration, trade fodder, tomato stakes, etc..
In the case of very high dollar, mechanically perfect, beautifully machined and engraved guns, personally, the fact that they go bang is pretty mundane and I appreciate them for their uniqueness, which is in the mechanical art involved and not that they will throw projectiles just like any other gun.
of course, some guns cost a lot mostly because they have features that enhance the shooting experience, such as high dollar trap shotguns. In that case the artistry is displayed in it's use, and I couldn't see myself paying that kind of money for a custom fitted shotgun or rifle then choosing not to shoot it.