By your content I’m going to discuss regional, not local service. For context I’m in one of the top 10 most populous cities in the country. There is no regional rail service. That’s how bad it is. In order to catch a train, it’s a 2 hour drive to a much smaller city.
But let’s look at a train trip I wanted to take. All west coast, Portland, OR to San Diego, CA. There is at least rail service that would do it. I think it took 48 ish hours with a middle of the night layover in Los Angeles. The drive is about 16 hours. The flight is about 2.
When it exists, it’s slow and super inconvenient.