Fulton Sheen turned from proselytising to providing a reassuring message for Americans of all faiths, drawing on his Irish roots