Much as I love Carrickfergus, it does have the line "I'm drunk today and seldom sober" - maybe not quite right for a funeral, even if it does mention death.
How about "John O' Dreams": even tho' the tune's "borrowed" from Tchaikovsky, a lot of the words are appropriate.
I also think the "Parting Glass" would be a good choice.