there is a story about two pipers competing all night and in the morning one of them walked outside and heard a lark and composed the tune lark in the morning on the spot. and thereby winning the competition..
(Seamus Ennis used to tell that story and then add - now here's the real tune that was composed..)
of course a lot of the names are pointless, just for mnemonics, and many tunes have multiple names, and there are a number of different tunes of the same name.. etc..
Supposedly Julia Delaney is Chief O'Neills daughter. She married piper Barney Delaney. And Mayor Harrison (of the fedora) was Mayor of Chicago.
I ll have to re-read Ciaran Carsons book (Last Nights Fun), Id recommend it for all session musicians.