Hydrogen fuel cells are lurking in the background too - and you don’t have to spend hours charging those.
Having electric plugs in supermarkets and doing some 15min breaks when using highways - that's already good enough.
I expect long-term we'll probably settle on something like 75% batteries / 25% hydrogen for ground transportation, and the reverse of that ratio for aircraft (although I wouldn't expect hydrogen planes to be using fuel cells).
Most of the new light rail and subway lines in the US are electric trains.
Taking a figure of half a million dollars per mile (which is less than the numbers I could find, but let's be conservative) you're looking at ~130 billion dollars. That's theoretically affordable for the government, maybe, but never going to happen politically speaking.