Jemima was a common enough name at one time, and it still occurs from time to time. Jemima Puddleduck is perhaps the most famous example of a Jemima.

Having three equally stressed syllables makes it a rhythmically interesting name to use in a song.