Obviously there is some latent risk in choosing a career anywhere, that the demand disappears. There can’t literally be zero risk of structural demand changes.
A broadly generalized super-automaton has long been a fantasy. Suddenly it's not so fantastical.
The problem in the Western world is that switching to a different career is made almost impossible. This society pushes people out of the workforce all the time. I'm one of them. I've been "unemployed" since 2012 with apparently ZERO ability to get any kind of skilled job ever again, just due to a "zigged when I should have zagged" situation decades ago.
I'm pretty sure there's literally zero risk of structural demand changes for law enforcement. Defunding the police isn't going to happen and there's no plausible path toward automating most of the work. Security cameras and robots can only do a fraction of what will be needed.