I guess it's a preorder/DLC weapon, hence why it wouldn't appear in vanilla. The other Legendary weapons are ingame unlockables - Hudson's pulse rifle, Hick's shotgun, Vasquez's smartgun, Gorman's pistol - all of those you can unlock and use in MP once you find them in Campaign.