shaggy dog story

A long-winded joke or tale featuring the narration of typically irrelevant details, and usually ending with an absurd or pointless punchline which is often a pun or Spoonerism on a known catchphrase.