I don't think wi-fi sync works with iPhoto, not the way it used to with USB, where you opened iPhoto and the iDevice showed up on the side to import the photos.
I think Apple's intention was for people to get the photos from their device into iPhoto is using iCloud and the Photostream. That's how mine works: all my photos taken with my iPhone show up in iPhoto when I open the program up, I don't have to manually sync and import.
I don't think you'll have this feature with iLife 09'. As you've mentioned, you can still connect via USB and import. I think there are other services that might do something similar, like keep a folder of photos sync'd from your iDevice to your computer wirelessly, but I don't think you'll be able to do it natively without upgrading to iLife 11'.