Andy Burnham went from mayor to prime minister, but the challenges facing Limerick’s mayor make a similar ascent unlikely in Ireland