That sounds like a rod knock to me, as in the motor is dead.

You could pull the oil dipstick and see if it sparkles in the light showing that the bearing is gone.