The car will last for as long as you are willing to pay for the needed repairs and maintenance. On any used car purchase; you are going to have to deal with repairs sooner than you would on a new car. The usual repair items that come up on a car with this much mileage on it are shocks and struts, alternator, water pump, front CV axles, timing belt, and automatic transmission. (That is why a stick shift is a preferred choice; both in cost of maintenance, and in fuel economy.) But there is usually no single repair that is so expensive that it exceeds the repacement cost of the car. So the question really becomes one of priorities: The point at which a person concludes that it is preferable to replace a given car rather than make a necessary repair is determined by their economic level, their customary status, and the availability, cost, and attractiveness of other vehicle options. Some people buy a new or a used car with the intention of keeping it for a lifetime. Sam Walton; the multimillionaire who founded Wal Mart stores; was known for his habit of always driving around in an old pickup truck. He obviously didn't feel the need to prove or demonstrate his wealth (or worth) to anybody. And old pickups can be very practical; in that they have lots of room to carry stuff around; they are reliable and simple to maintain, and you don't have to worry about scratching the paint.
But having worked for a long time as a consultant on car purchases; I will say that Hondas from the early 2000s were close to the peak of their historical quality. Their engines, brakes and electrical components are not quite as long lived as Toyotas; but the difference is not extreme. A vehicle that has averaged about 20,000 miles per year in its lifetime has a big advantage over other used vehicles; in that it requires mostly freeway driving to rack up that many annual miles, and freeway driving is the easiest type of driving on a car's potential longevity. Because of this; I would expect the engine in that car to last somewhere around 250,000 to 300,000 miles; given proper maintenance. And one often overlooked element of that maintenance is to find out from the owner what brand and weight of oil they have been using in the car; and strive to continue using only that same oil brand and weight (both at oil changes, and whenever oil has to be added between changes). This will do more to prolong the life of the motor than anything else I know of. But all too many skeptics do not believe such advice (much to their detriment).
I hope this information enables you to make the best decision about this purchase.