

U-238 (the most common isotope in natural uranium, present to an even higher degree in depeleted uranium which has had the shorter-lived U-235 removed) has a half life in the billions of years and with such a long half-life life even with a large mass of the material you won’t be getting many radiological decays occurring. Which is not to say it’s good for you to ingest or contact, it’s definitely not, but that’s more due to the chemical properties it has as a heavy metal (think like how lead is bad for you) than its radiological ones.
Fission products formed in a nuclear reactor on the other hand have half lives all over the place from tiny fractions of a second to days, years, millions of years and so on. So you can get a high dose from short-lived isotopes going through many decays if you happen to be around them while they’re freshly generated, and intermediate life isotopes can persist in the environment for sustained periods while still dosing up the area. So a flying nuclear reactor venting its exhaust over you is quite a lot worse radiologically speaking than some depleted uranium being in your environment, though that said the chemical properties of having uranium in your drinking water or the physical properties of a high density round shot at you are plenty bad regardless of the radiological harm being often overstated.
I’m speaking to radiation since that’s my interest. The specific activity of uranium is generally around 14.8 Bq/mg vs. 25.4 Bq/mg for natural uranium, where one Bq is one nuclear transformation per second. That sounds like a lot but as far as radioactive materials goes is incredibly low. The Americium-241 used in smoke detectors for instance has 127 million Bq/mg.
As I said before there certainly are health impacts but they are largely arising from the chemical toxicity, not the radiological activity. It is ONLY the radiological aspect where I said the risk was overstated, I recognize that the chemical one is very real. For example, the WHO 2001 report on depleted uranium that your second source cites gave a limit on depleted uranium of 0.28 mg/L in drinking water for its radiological toxicity… and a 140x smaller (!) provisional guideline of 0.002 mg/L for the chemical toxicity.
Your third source states this in its summary: