Sounds like the bearings in the carrier are either seized or completely destroyed. This is what happens when either of those are the case. Tightening the chain pulls on the axle and puts it in a bind. Show us a few pictures of the axle right where the sprocket hub goes into the carrier.
Welcome to the forums!
Welcome to the forums!