Yeah, that sounds like a rod bearing, and yes it means the motor will have to be rebuilt, or replaced. Replacing it with a good used one is likely your cheapest way out, but if you want to have it...