A broad retrospective study cannot refute a randomized, placebo controlled trial. And its the exact sort of study that is very easy to manipulate.

There are actually companies that do this as a marketing tool. They literally design retrospectives to give or present certain results from the outset.

If you think you have proven something by pointing to a retrospective study and think this means we can just never do the actual placebo controlled trails (or ignore their results). Then you are explicitly rejecting good science because bad science justifies your bias.