The incident certainly took place, just a few years ago, and IIRR Elizabeth II was in her bed at the time. Fagan (sp?) was pronounced of unsound mind or something, and I believe a few heads rolled (figuratively speaking ...) because he'd managed to get in at all, let alone to the Queen's bedroom, entirely undetected. But I haven't come across a song about it.