It actually works pretty well, considering how much they do shoot down, but if there is enough incoming, some will get through.
As long as you don't look at the receipts yes, technically it works very well, in every other aspect it's a massive waste of resource and money.
https://abcnews.com/International/us-allied-radar-sites-midd...
This biggest loss was the mobile THAAD radar in Jordan https://en.wikipedia.org/wiki/AN/TPY-2_transportable_radar There's also evidence they hit a building in Saudi Arabia containing a AN/TPY-2 but it's not clear if it was damaged
Plus a couple videos of fixed radomes getting hit by drones
Defending against ballistic missiles is well known to not be perfect, even against Iran's lest sophisticated missiles it's very difficult. But the high end missile systems are worth trying. The main problem is the lack of cheap drone interceptors which has been a blaring siren since Ukraine war started that the US neglected by not treating it as an emergency.
The C-RAM was in Baghdad, the high end radars hit were in the other gulf states.
The CWIS is probably the best anti-drone tool the US has but they have far too little of them and can get overwhelmed. They should have listened to Ukraine.