Heavier batteries are energy denser than batteries made out of the same material but lighter. If you have to store a lot of energy, the answer is clear, you need a heavy one. But, if you need to save weight, you must compromise between the energy you need and weight.