Back in the 1960s and 1970s, there was a trend in what was called the "New Wave" in science fiction to come up with reallllly long titles. One example comes to mind: "The Wine Has Been Left Open Too Long, And The Memory Has Gone Flat" by Harlan Ellison.
I know there were some long titles in a lot of progressive rock songs from that same period, but I can't remember any of them. And I don't even have the excuse that I was alive and partying during that period (I was alive but just a toddler then).
The ones I can remember:
Spiritualized--Ladies and Gentlemen, We Are Floating In Space
King Crimson--In The Court Of The Crimson King (including The Dance of the Fire Witch)
Best I can do. 