The Royals weren't expected to compete for the Brendan Martin Cup after a slow start to the year but made it to the Croke Park decider in early August