What is the title of a classic rock song with freight train in intro?

The song you're referring to is "Midnight Special" by Creedence Clearwater Revival. It was released in 1969 and features a train-like rhythm in the intro and throughout the song.