Not useful? I guess that's why they were one of the most (if not the most) commonly used weapons in the history of warfare.
I just wish they were included because I feel like I would enjoy the spears more than I would a lot of the trivial things that were included.
They have been commonly used because in war, men fight in groups. A long spear was the primary weapon of the Greek hoplites, who fought in the close-ranks phalanx formation, with a short sword as a secondary weapon. The Roman soldiers, who fought in somewhat looser-order formations, used a pair of javelins (the
pilum, plural form
pila) as their opening weapon, then switched to a short sword, the
gladius. There have been spears and other polearms used by soldiers in well-ordered formations through history.
But in the battles in Skyrim, which are usually one on one, or at most several against several, the spear is less useful. They're easier to evade and are useless for parrying. A block of spearmen in close formation with long, eight-foot spears can be nearly invulnerable against an equivalent number of swordsmen. Give them some longer spears and they'll drive off cavalry. But put one dude with a spear up against one dude with a sword, and the guy with the sword will knock the spear out of the way, drive in close and use that sword in combat, too close for the spear to be much use.
This is all discussing a relatively realistic heavy hand-to-hand spear, or a still-heavy pilum designed to be thrown into the enemy's shield. That spear you saw in the video wasn't a spear, it was a bo staff with a pointy end. A stick with a sharp end is only so useful against enemies in even light armor. They'll have no mass and no strength to penetrate armor. That spear in the video was just that - a stick - and that's why they were spinning it around like a stick or a bo staff and stunning the enemy. You could do that, but it would be useless against anybody with metal armor on. Make the spear heavier, like a real infantry spear, and then it becomes a dangerous offensive weapon - but you wouldn't be doing any of those fancy spins and bo staff stunts.
But again, the OP wasn't asking why people wanted spears, he was asking why people were
upset about their absence. Wanting spears is fine and rational; being
upset that they aren't in the game is just damn nuts.