Yes, definitely. If they can send MIDI to SP, then you can use them in the software to do all kinds of things. There’s a Pad Input type that is specifically for these kinds of MIDI devices - triggers, SPDs, etc. Pad Inputs | Sensory Percussion 2 Help
And, yes, SP2 can be used to control Superior Drummer. We have a template available to help with that, too. You can read more about that here: Sensory Percussion 2 to Superior Drummer 3 Template with Cymbals - #24 by Aka_Wayne