I also have the same adapter and it works with my USB to Serial adapter. Just a Gigaware I picked up one day at RadioShack.
Their FAQ may just say that so they don't have to bother troubleshooting support calls about why certain ones don't work. I have a USB to Serial adapter from AB that won't work with the adapter, but the Gigaware USB to Serial works just fine. The AB one I have will "see" but drops connection repeatedly and won't allow you to monitor or use the Upload Station to PG option without failing.
I guess the basic question to ask, does the 6ES7 972-0CA23-0XA0 adapter power up when you plug it into the MPI port? It may or may not have power available.
If it is powered up, it may be an incompatibility with your USB to Serial adapter. Not all of them will work with the MPI adapter.