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