Did "The Rain Song" start as a folk piece?

Yes. It began as a gentle acoustic thing Jimmy Page had lying around, and Robert Plant’s lyrics fit it. Then they added the Mellotron, crescendo, and heavy middle section to make it the epic eight-minute track on Houses of the Holy. The folk-to-hard-rock transformation is what made it work.