Gallery2 as Intranet Digital Asset Manager?

At work, we currently do a poor job of managing our pile of images. We have a number of folders, many with clever naming schemes, maintained by multiple people. We're always on the edge of using an image that has not been approved for external use (we're a gov't contractor, so this is a critical piece.)

We're starting to look at better ways to organize our photography and I remembered giving Gallery 2 a shot on my personal website a while back. I'm discussing a workflow like this with my coworkers and would love some feedback from people in similar situations.

- After the photo shoot, archive all photos from all cameras onto DVD. Duplicate DVD and send 1 copy offsite. Other copy stays in offline library.
- Images imported into Aperture for sorting, tagging, rating, and rejecting. Only photos that meet a criteria (yet to be formalized, but say 3 star or higher) will be exported from Aperture.
- Photos exported from Aperture are imported into Gallery 2.
- Photos in Gallery 2 are organized by photo shoot (YYYYMMDD_Photoshoot or something) so we can go back to a specific day.
- Queries are put together for product-based, on-the-fly "galleries" ("Show me all photos tagged with Widget-A")
- As photos are approved for external use, they're tagged "Approved" in Gallery 2 (can you do this by folder or batch apply tags to a selection of images?)

Is this a reasonable approach? Will it stand up to large libraries? (terrabytes of photos)

Any recommendations/best practices/lessons learned from others in similar situations?

Thanks,
-Ben