currently its very bad, vs aggro its bad and vs control they destory it or even worse - sticky finger it.
It's most definitely not bad against aggro, as long as you're playing it in the right deck. Sphere of Sapience is best in decks with polarized cards: some you want, some that do nothing. In those decks, Sphere can be game-winning, getting you your board clears and leaving your combo pieces on bottom (or the inverse against control). It also is great at preventing low-rolls like drawing Vargoth or Potion of Illusion. Easy craft for any deck fitting these qualifications (preferably one that does not attack with their hero).