The phrase end of the road means a situation has reached its final point and cannot continue any further. It is a literal idiom, drawn from the image of a road that ends, and you cannot travel further along it.
We knew it was the end of the road for the old car.