Its not increasing points of failure, it is overlapping security features. If your first response fails, you got your second response, then your third response. There is no single thing which can fail and take down the whole system.
If you want a comparison just look at the bodies immune system, multiple overlapping redundancies.
And, barring the intervention of modern medicine, the human body lasts a handful of decades. Even WITH the best care and healthiest lifestyle, your multiple overlapping redundancies last a century (maybe a smidgeon more) at best.
Which is why most manufacturing plants dont rely on a human to jam a microchip into your computer with their thumb.
And as errors creep in they get fixed or replaced.
How? There's no outside fixes. You're too far away for any reasonable chance of communication, so, all errors must be fixed by the thing that is malfunctioning. That presumes that the programming is good enough to actually recognize an error and that the programming that recognizes errors remains uncorrupted for centuries or millennia.
It has never been my argument that you can make something that will last forever. Hundreds of years is probably all that you would need to explore the Milky Way completely.
See, that's the problem. You flat out cannot explore the Milky Way in centuries. Not without faster than light travel anyway. We're not talking centuries, or even millennia. We're talking truly deep time - megayears. Again, unless our understanding of the universe is really, really flawed, and there's no current evidence that it is, that's just not possible. There are just too many things that can go wrong, and, given the timespans we're talking about, the chances of failure are pretty much guaranteed.
Heck, entire species don't last a million years sometimes. The universe is a very hostile place.
At best, we might make the nearest star or two with probes, but, that's about it. Actually establishing colonies? Not without some serious changes in our understanding of the universe.
Even something like colonizing Mars, in the long run, isn't feasible. It took billions of years to make Earth as habitable as it is. Domed cities? Great. But, over the long term - as in hundreds of thousands or millions of years - that won't work because eventually you won't be able to replace lost resources in your dome from Earth. Even if you do manage to turn Mars into a "living" planet with a functioning ecosystem, gravity will eventually get you. Mars can't support life indefinitely. The lack of gravity means that the atmosphere will eventually bleed off. Lose the Earth and Mars dies.