US Navy SEALS have pretty much open door to use a lot of weaponry while on duty, in my 20 years in the NAVY I don't ever recall any SEAL using SW revolvers, for the most part I saw SIG 226 and 229 . Here is a link that might provide an idea as to what they use.
Navy SEALs Weapons
Lou