We optimized the service to work with any container instead of eliminating cost. If you're not getting requests you have a reduced cost for consumed memory and instances but by keeping one warm it makes it so you don't have to engineer around cold starts.
We may add scale to zero in the future. Would love to hear about your use cases on the public roadmap https://github.com/aws/apprunner-roadmap/projects/1