Essentially lets you keep have browser tabs with entirely separate cookies from each other (like if you opened it in a different browser). Helps me keep work and personal accounts apart, and also sandbox eviltm webpages I'm forced to visit (by giving them their own container).
I almost forget it isn't included in firefox by default.