Serpent Sting uses the same animation, and you can use it regardless of what weapon you have equipped.
It’s pretty weird that one requires a melee weapon, and the other does not.
ESPECIALLY because the exact same spell can be used in MM/BM with a ranged weapon.
This is not a balance concern, since Survival should rarely ever be using ranged weapons, but it’s really weird if you do want to swap while questing or something, that I need to have a spear equipped to pull out my crossbow for a kill shot.