is there any documentation on how automatic schema discovery works?

AUTO_DETECT_SCHEMA=false

Is this supposed to pull in changes to schema at the start of syncs?

This feature is still in development, you can track progress here: https://app.harvestr.io/roadmap/view/pQU6gdCyc/airbyte-roadmap?p=bj4hNcr3h