Kate said
""The Next Market Day"
It's about a young lass who is led astray by a piper who offers to teach her a new tune, but it doesn't end badly. "
I thought it ended up with her cheerfully going off to search for him, leaving you wondering how happy she might be 9 months on.

And I thought "Do you love an apple, do you love a pear," was from the N.E|. of England.
Another cheerful sounding song until you stop to think about it.