Yes, there simply hasn’t been enough time for proper studies to have been made one way or the other [0]. The only “study” showing in vivo efficacy is pretty much a bunch of bunk and has huge issues. It did not report on actual treatment outcomes but only on nasal swab results without a control arm, never mind that covid-19 has been demonstrated to move from upper respiratory down into the lungs in most cases that progress to pneumonia or respiratory distress anyway (so a nasal swab says nothing and can come back negative while the patient is dying of respiratory failure).

[0]: https://www.cebm.net/covid-19/chloroquine-and-hydroxychloroq...

That means your claim that it “only works in vitro” is false, though. The right claim would be “we don’t know yet”.

Also you do a lot of work to make it sound like a foregone conclusion it doesn’t work (appeals to authority in “anyone paying attention”).

The problem is there is now a lot of anecdotal evidence of it working from good sources (teams of doctors on frontlines from around the world). So really you can’t appeal to anyone paying attention.

Yes, so far as we know.