There's no reason to ever use live rounds, even 'blanks' on a set. While accidents of this nature on set are rare, they shouldn't be occurring at all. This move to using CGI to portray muzzle flashes is the safest and smartest route and I hope to see more movie and tv productions take this route.
ABC’s ‘The Rookie’ Bans “Live” Guns on Set
The change, effective Friday, comes in the wake of the fatal shooting on the set of Alec Baldwin's 'Rust.'
I thought they had ended use after the Brandon Lee tragedy. Unfortunately, I was wrong. I can't even wrap my brain around the logic of using real guns on a set. Modifying real guns to be 'non-lethal' when a good prop dept can fabricate a realistic-looking facsimile is downright dumb and dangerous.