Can the SP//dr hero or ally have Warrior of the Great Web attached?

No. A character’s title must contain the word “Spider” spelled exactly that way in order for Warrior of the Great Web to be attached.