The super deluxe edition of the game is almost double the cost of the base game. It includes the full base game, the Firehawk's Fury Weapons Skin, the Ornate Order Pack, the Bounty Pack Bundle, the Vault Hunter Pack, and the preorder bonus Gilded Glory Pack. The main reason to get this edition, however, is for the additional DLC content and playable characters that come with the Bounty Pack Bundle and the Vault Hunter Pack. These two add-ons include new areas, missions, bosses, regions to explore, and two additional playable characters that don't come with the base game.
Is It Actually Worth a Preorder?
If you're on the fence about deciding whether or not it's worth preordering, I'd say it really comes down to whether or not you're willing to pay full price for the game, whether or not you care about the preorder bonus, and whether or not you care about playing the game on day one. It's unlikely that the price of the game is going to really drop until next year, so if you do really want to dive into it on day one then there's really no reason not to grab a preorder now. The bonus you get is just some additional skins and weapons, so if you don't care about that the real benefit is getting your copy as soon as possible.
Like with any AAA title, however, it's worth noting that there will likely be bugs you'll be contending with in the early days of gameplay. Randy Pitchford has already made comments about the day 1 patch you'll have to download once you actually have the game, and it's highly likely even more patches will come. So if you want the best possible gameplay experience, it's probably worth waiting a bit until all of the kinks are worked out.
Personally, I plan on waiting until the game gets discounted simply because I can't stand paying the full price for any video game anymore. I'm definitely excited to play co-op with my dad, but since he's retired he'll blow through the whole thing on his own multiple times before I'm actually going to be ready to jump in there with him so there's no rush for me to buy now.