As Foo Fighters get ready to rock Dublin, Ed Power traces Dave Grohl’s journey from the wreckage of Nirvana to fronting another of the biggest rock bands on the planet. It’s a tale that also has a surprising Irish twist