I’d argue otherwise. Their can be. It’s not required, but it’s the difference of using CGI or practical effects. John Wick didn’t use real guns, but it’s the perfect case for that. It’s fast action with a lot going on, so you’ll never notice that it’s fake. I would argue more intimate shots it can make sense to use a real firearm.
They shouldn’t be used where it’s possible to avoid, and even when it can’t be avoided aiming it at someone should be avoided. There should also be checks and double checks to ensure there isn’t a live round, and the actor should also be trained to handle the weapon and check there isn’t a live round before using it as well. There is no reason something like this should have been possible, but I don’t agree there is no use for using a real firearm ever on set.