That is pretty ■■■■ funny man. You should see my first attempt at socketing a weapon on a 2D character it went about as well as yours did here only with lots of other issues.
Best advice I have is review a couple more socket tutorials to try to figure out where it went wrong. Did you spawn the actor to the socket or was the object already within the world space? The 3D socket tutorial I saw had the object already spawned into the world and when it needed to be socketed it “snapped” the object to the socket. If you do it that way you can scale the sword to the right value first then shove it under the floor or in an out of the way out of sight location until it is needed. If you spawned it directly to the socket without first bringing it into the world it may have spawned in with the wrong scale and you might need to tell it the scaling values at spawn time but this is a poor way to handle it I think.