It depends, but the general rule is that the older it is, the less people want to see it in active use. At some point it's about preservation over anything, but there's also the safety concern! A firearm is a very dangerous thing in failure mode, so at some point a firearm is both too historically valuable, and too damned dangerous to fire.
Source: Forgotten Weapons and Royal Armory youtube channels