I think "a lot of places" is doing some heavy lifting. There are a few cities in the US that have a train that connects to the airport but not many.
If your city doesn’t host a large airport, then it probably doesn’t make sense to have a train system either. And I’m quite confident there’s a bus to the airport in just about any city that has one.