If someone whimpers, they make quiet unhappy or frightened sounds, as if they are about to start crying.

If someone whimpers something, they say it in an unhappy or frightened way.

If you say that something happens not with a bang but a whimper, you mean that it is less effective or exciting than was expected or intended.