I daily drive a 1997 Dodge Ram pickup, with roughly a quarter million miles on it, and it still works perfectly.
My previous vehicle was a 1984 Ford F350, which I purchased for $800 in 2017 and then subsequently drove from Seattle to North Carolina with only one breakdown (that I could fix roadside).
With proper maintenance and repair, most vehicles can last several hundred thousand miles and 30+ years. The lack of representation of these vehicles on used car search sites is that most of these inexpensive vehicles are sold private-party. Look at your local Craigslist site for examples.