It's weak evidence because COVID-19 observational studies are riddled with confounders due to COVID patients generally throwing everything at it they can to try and stay alive.
The exact same pattern occurred with hydroxychloroquine. Lots of small observational studies showed promise. Then it repeatedly failed large RCTs. It turns out that the people with the resources to use HCQ also had the resources to use other things, things that were actually effective.