It’s not clear what you’re trying to do with the socket transform. Currently you are taking the socket rotation, and rotating a vertical vector (0, 0, 180), which is why you’re getting a vertical trace.
At a guess, what you want is:
SocketLocation → Start
SocketLocation + SocketRotation.ForwardVector * 1000 → End