Incite. Inspire. Provoke someone into action. Strongly urge someone to do a chore. A fire lit under your butt or feet would surely force you to move and become active, so this phrase indicates a forceful pressure to act.
“Wanting to buy a car has sure lit a fire under him to get a job and earn money.”