You can see the list of currently supported hardware on the Zaurus project page at
www.openbsd.org. It does still omit a few known to work cards like the Socket 10/100 CF card that I added but it covers the Zaurus stuff generally quite well.
I don't actually have one of these cards to test.
It is feasible that it may look like a CF serial card to a driver and be immediately recognised and you would then be into writing a camera application to manage it.
It is also feasible (I haven't looked at any of the Sharp kernel source for a while) that the camera may need a firmware download from the driver and/or the card may need special handling because it doesn't actually look like a CF serial card and the driver abstracts it - this could be a lot of work, but as I said I don't really know because I haven't looked at the original source for the driver.
-Andy