The Cork-born driver and aide survived wartime danger, served alongside Eisenhower and later became the subject of enduring speculation