That was horrific and so deeply tragic. Without diminishing that I would say this kind of event is extremely exceptional and there's an enormous bar to a police officer even carrying a weapon in the UK and that was an Mi5 failure.
Person who authorized that was promoted into becoming the (now former) head of the metropolitan police btw.