Most people only remember the initial publication and the noise it makes. The updated/retractions generally are not remembered resulting in the same "generally, no consequences" but the details matter
In my area we have a few research groups that are very trustworthy and it's safe to try to combine their result with one of our ideas to get a new result. Other groups have a mixed history of dubious results, they don't lie but they cherry pick too much, so their result may not be generalizable to use as a foundation for our research.
[1] Exact reproduction are difficult to publish, but if you reproduce a result and make a twist, it may be good enough to be published.
(And I think part of the general blowback against the credibility of science amongst the public is because there's been a big emphasis in popular communication that "peer reviewed paper == credible", which is an important distortion from the real message "peer reviewed paper is the minimum bar for credible", and high-profile cases of incorrect results or fraud are obvious problems with the first statement)
Also, many sites just copy&paste the press release from the university that many times has a lot of exaggerations, and sometimes they ad a few more.
[1] If the journal has too many single author articles, it's a big red flag.