After rolling, does the players security team card that's been committed to the mission get discarded? If so, the hypospray card could retrieve. If not, does it stay for the next player to use? Or do they need to contribute their own card (the way we played it)?
You played it correctly. You commit a Security Team to the Mission, then roll. Regardless of the result, the Security Team remains committed until the Mission is resolved.