How do i make text shatter, like as seen in many of the bumpers for the 2009 Nickelodeon rebrand?

That's not AE, that's 3D animation. They may have doen other stuff in AE and/ or imported pre-created baked 3D animations e.g. as object sequences to be rendered in Ae, but there's no way to create a shattering animation with secondary collisions and volume retention inside AE. That requires far more sophisticated simulation tools. At best you could potentially fake it with custom shatter maps and lots of work in the Shatter effect and spice it up with some extra particles, but why would you? these days that's a five minute simulation setup in pretty much any 3D program, including the free Blender. No point in wasting your time in AE.

Mylenium