Error-free is not the goal, which is the author's point. Citation metrics and grant funding chasing mean the goal is not to be error free but attention grabbing, sensational, a step towards getting a big fat grant or even error filled so other people are forced to tackle the problem and cite you
Where did you get the idea that error-free research is not the goal? The author even mentions this:
Recently, I have bumped into multiple cases where I believe the correctness of the results, the honesty of the people writing them, or the lack of curiosity once they are told that their results are wrong, incorrect, faulty, or misleading, has been unsatisfying.
Note "I believe the correctness of the results....has been unsatisfying." Sure it might be unsatisfying for the author but on average the correctness is only increasing because of the increased scrutiny