It should work with OpenACS right off the bat I think. I am not into it very much. I don't know how database driver issues are handled and I haven't heard of anyone that has put OpenACS to work with mod_aolserver yet.
Actually, I haven't heard of anyone using mod_aolserver with ACS Classic either... only ArsDigita and strictly for testing and demoing. All their production servers run AOLserver as far as I know.
The purpose of mod_aolserver is to replicate the AOLserver API within Apache, so that AOLserver programs can work without any modifications inside Apache.
You're more than welcome to try it out and let us know how it went though.