The station at Rocamadour is 5km from the village itself. A nice walk on a nice day, perhaps not if it is raining. I am sure you know that only three trains stop there on Sundays.
Rocamadour is pretty popular but the hordes of July and August will have gone.
Sorry I cannot help regarding accommodation as I have never stayed there.