Okay, fo sho the SSD will rofl the 7200rpm. It will rofl the 10000rpm. It may even just rofl the 15000rpm drives (note that this does not include the Seagate Cheetah...that uses a SCSI interface anyway)
Now the way SSDs work is that there are cells (either SLC or MLC) that are grouped into pages which are grouped into blocks. Pages are the smallest thing you can read/write. To erase, however, blocks are the smallest. Because of this, when you delete a file, it simply marks the pages as inactive. Once your SSD is filled with inactive pages (probably in like a day or two despite you using of only like 50% of actual storage) when you go to write something, since there are no more empty pages, it will read the amount of inactive pages it needs to a temp location. It will erase those inactive pages in the temp location, then copy your file into the temp location. Then it will erase the original (not temp) blocks. Then copy the temporary stuff back into. This means in order to write, it does a read, write, erase, read. This is why it's slower.
TRIM simply moves that to a diferent location. So with TRIM, when you delete a file, it doesn't mark the pages invalid. It just does the above process. So that read, write, erase, read process is moved to when you delete instead of when you write. This is good because it's a little better in integrity when you're writing an important file.
Nevertheless, even with the SSD slowed down with that process, it still owns the 15000rpm.
It only helps the most with the loading screen and not too much with the in game play.