It won't work.
The dedicated PSP camera (Chotto Shot/Go!cam, which are the same thing) acts as a host to the PSP, which is a slave. It's the same issue with hooking up a HD to the PSP. That camera acts as a slave, with the computer as the host, so it won't work.
Hope that clears some things up.