Destro is closer to overpowered than it is to being weak right now… It’s not really mechanically any different from regular vanilla, you just launch a green or orange ball instead of a purple one to start your combo in sod.
That being said, there are some changes… Most notably, priest homonculi will basically 100% shut you down the entire time they’re active, if they are directly cast on you, and they’re immune to fear as well… That one thing aside, if you knew how to position in pvp to be able to cast in normal vanilla, you will be fine in sod p2… We can be crippled while focused, but there’s very few classes that are even threats to us overall…
Our biggest counter class historically is ranged hunter, and they’re not doing so hot right now. Boomkin can be another problem class since they can stun when they nuke, have high spell resists (of you try and control them with fear or seduce it seemingly always breaks super fast), and they have the mobility to moon fire you then jump back out of range before you hard cast… Then shadow, but only with homonculi being used on you. If they cast it on anyone else, you’re free to blast them, and at least in bgs a soft counter to them.
Beyond those, rogues and feral can both put a beating on you, but again, positioning makes you an incredibly unattractive target… They have to waste time stealthing around a battle to even reach you, then when they open, they’re surrounded by enemy players and usually something like 60+ yards from their nearest healers/peelers.
Warriors and rets, should never touch you in bgs. Ditto melee hunters. I can’t speak for shaman, tremor totem never seemed that reliable on my shaman alts in Classic/vanilla, but grounding, earth shock, and ability to “throw” earth bind totem are probably a decent kit to at least get some melee uptime