As for small loads, this is where combined shipping comes in handy. I believe many of the shipping companies like UPS and FedEx used to do a lot of ground shipping via rail for their 5-7 day deliveries. I don't know about this anymore.
To get from the rail station to Walmart... you must have trucks.
No way around it.
Trucking from the railhead is probably unavoidable, but the article talks about a 1000mi trip, whereas according to wikipedia at least, greatest distance across the 48 states is 2800mi. Surely the nearest freight depot should be less than 1/3 of the country away?
http://maps.google.com/maps?q=Harbor+island,+Seattle,+WA&...
I don't know much about it, but the machinery at the port looks really impressive. It seems to lift cargo from the ships onto the trains.
[1] https://secure.wikimedia.org/wikipedia/en/wiki/Personal_rapi...