I just installed the latest Sony drivers on a new Macpro running Lion and cannot see the S X S cards/drives on the camera when I plug in the camera to the computer via usb. Also no indication from the camera that it is plugged in like in Snow Leopard.
The drivers are not required unless you are using a built-in express card slot. Have you looked in System Profiler or Disk Utility to see if the camera is seen at all? You may also want to check on another machine. Call the tech group @ 800 883 6817 or bis dot product dot support @ am dot sony dot com, they should be able to resolve as long as nothing is broken.