Really depends on the gun to some degree. There’s collectibles that are worth more left alone, especially old stuff pre modern ammunition. But lots of old but not that old stuff its more or less expected you’ll fire it to test it works on receipt.
For example - an M1903 is an antique by any definition, and you'd be hard pressed to buy one today that's unfired.