No, rod knock generally gets worse when accelerating. This is because rod knock is caused by damage to the piston rods and rod bearings. As the engine goes faster, the pistons will also go up and down faster and this will amplify the effects of rod knock. Rod knock generally sounds louder as the engine heats up and as you accelerate faster.