‘It was like turning the Titanic slowly’ – how a reluctant supersub became Dublin’s matador