All V6 manuals have the same tranny, regardless whether it's an SVT or a Cougar or a Mystique. The only difference is that there are rod-shift trannies in the early Contours, which would not work in your SVT. All SVT's are cable shift, as are all manuals from 96 onwards.
So yes a Cougar tranny will work.