"How would you design a pinger suitable for shipping containers so that they could be located after being dropped overboard?"

You don't. Black box pingers have a range of approximately 5k meters. Which complicates matters if your depth is in that range.

And for what purpose you'd want that again? Claim the insurance.