Pike is one of many newbie traps intended for trolling inexperienced players. Yes... Newbie traps are vital part of Dark Souls.
It looks dangerous and from description and requirements you can say it has to be a good weapon right?
Well... No. If you are looking for long range poking weapon Moonlight Butterfly Horn, Demon's Spear or Silver Knight Spear are far more superior and if you just want to use a spear any other spear is better than this.
So what's wrong with Pike? High requirements compared to moderate damage, useless charge attack, heavy weight and large stamina use.
Well of course you can kill any enemy and boss with this. Of course you can make build oriented around maxing it's damage for very high values. Sure it's DS you can do anything you want and use any approach. But all of this doesn't change one fact... You'll do same thing much easier with other weapons.