Don,I don't know what to tell you. Some dancers and instructors are as enlightened as you mentioned- they know "THE reel" or "The light jig", while others actually know tunes.
Some of the dance practice cd's don't even list tunes- they have what you mentioned "hornpipe" etc. Some dance cds that DO tell you names include: Sets and Solos (Vol 1 & 2) Step in Time One More Time (Culkin School of Irish Dance) played by Brendan Mulvilhill, Billy McCommisky and Zan McLeod