Photo indexing software for Mac OS X 10.5.8 with the ability to upload to a photo printer / sharing service?
That's precisely what iPhoto is for.  Google has discontinued the Picasa exporter for iPhoto, but there are numerous other exporters including:

Flickr exporter, and an exporter for Shutterfly.