Mining giant BHP has agreed to press ahead with its biggest acquisition in a decade to boost its exposure to metals needed in the clean-energy transition.