It's like the bar code on a security.
Many stocks and bonds have multiple flavors, some that are very, very similar. Trying to keep things straight can be confusing, and tacking on CUSIP numbers helps to clear things up a bit. Having a unique CUSIP allows for the securities to be individually identified so when you think you were buying a cow, you actually get a cow... and not a bunch of magic beans.