It got published, people noticed it, people saw it was bullshit, it got retracted. Publishing is not the end of the line.
It's an extreme example, but it's still an example of the system working in the end. Reasonable people are supposed to question what they read, not blindly trust it, that's how you catch "important shit".
The problem is not that some bad papers get published. The problem would be them staying unchallenged. And it's also a problem that laymen consider one random study is an undeniable proof of their argument (potentially ignoring the thousands of studies contradicting it).
I am not disagreeing that this is ridiculous, I was just saying that this stupidity is not what should convince people not to take some random paper for an absolute truth, just because it was published.
Even if you eliminate fraud, bullshit and even honest mistakes, that's just not how science works.