You are very unlikely to see a material concentration of this stuff unless you’re very close to the site of the explosion. The risks, if any, come from people handling hunks of it like armor plating and bullets .
This study from 2020 found an 89% increase, which is a large effect size, but it’s still just 1’s of people per 100,000 more getting cancers. It’s not a massive public health hazard. War is complicated.
Regardless the effects are highly localized. You’re fine if you’re not nearby.
It might all be 'highly-localized', but DU is there to stay in the ground virtually forever, until it is blow elsewhere by the wind of carried underground by rain, both of which are equally undesirable outcomes.
There’s no evidence that this stuff can blow elsewhere at concentrations sufficient to cause harm very far (maybe a couple dozen miles). Hence, “highly localized”.