Until he is activated, nothing appears when you mouse over the Titanic Guardian. He's the huge statue standing on the lower level. If you accidentally went to the mid level where you turn your quest in, you ARE able to fly in there; so you can easily fly down to him to activate him.