"In sorrow we must go, but not in despair. Behold! we are not bound for ever to the circles of the world, and beyond them is more than memory, Farewell!"
Doesn't sound so unhappy to me.
Aragorn did not succumb to fear; Arwen did. That is the tragedy.