The damage potential of the casket is wildly variant. The average roll on 3d6 is 10.5 and you get a BSB reroll against it, and stuff like cold blooded helps as well (4d6 drop the lowest), so against many armies its damage potential is quite limited.
Against Vampires...not so much. As everything in the army is quite low LD anything outside the LD10 IP bubble is toast. A LD4 terrorgheist, for instance, dies to an average roll. However, if you cram everything into your general's bubble it's now all very close together, meaning it can potentially bounce across your entire army. Now that depends on how hot your opponent's dice are, as I've had my caskets bounce through an entire army and not kill a damned thing...but then I've also had it eat an entire LD9 chaos knight unit so YMMV.
That said, it's not THE strongest spell in the TK's arsenal, which is really it's raison d'etre. A good tomb kings player will have at least 8 wizard levels in the army, and can throw out a very serious number of potentially crippling spells. -D3 movement on your GG bus, and DT checks any time it moves? Yikes. 3d6 S6 hits from banishment against your terrorgheist? That's a dead 'gheist right there if you let that through. And if you let him get a purple sun off through your army...well...we all know how that can go. A good TK player will throw nasty spell after nasty spell at you, saving those last two dice for the casket knowing that you'll have to keep at least two of your own back to stop it.
Basically, the real strength of the casket is a psychological one.
(ps. remember that even with two caskets a unit can only be hit with the bound spell once, so he can't double-tap your BK bus with it or anything)