> So systemd is doing a reverse proxy for Apache in that configuration?

Nope, systemd only opens the socket and passes the fd to Apache.

> Or is it launching Apache on demand like some sort of advanced inetd?

Yes. Since it's already init's job to start services, it does not make any sense to have a different system to start socket-activated services.