Yet another study that "explains it" turns out to be false. Good.
It is definitely a good thing.
It is good that the conclusions of a study that was demonstrated to be unsound have been replaced by those of a better study. If some even better study comes along later and replaces this one, that'll be good too. We now know more. It's not fun or convenient, but is generally aligned with the direction science should go.
If people who've made decisions based on their understanding of the results of this study, it's good that they'll no longer labor under a delusion, and can potentially make better decisions.
Good in the sense that hard things which make us incrementally better are good.
But, yes, good to be aware of the possibility of both false positives and false negatives.