Yes, the 2nd sentence is awkward.
"longing to visit" is the correct phrase to use.
You can only "long for" an object.
That place has been longing for me to visit. (The meaning of the sentence is changed here, but this is how "longing for" could be used.)