Move `autopilots` into `autopilot_state` #7529

Job	Run time
analyze	26s
test-mysql (1.22)	7m 15s
test-mysql (1.23)	6m 38s
test-sqlite / test (1.22, ubuntu-latest)	5m 30s
test-sqlite / test (1.22, windows-latest)	10m 43s
test-sqlite / test (1.22, macos-latest)	7m 16s
test-sqlite / test (1.23, ubuntu-latest)	5m 21s
test-sqlite / test (1.23, windows-latest)	8m 25s
test-sqlite / test (1.23, macos-latest)	6m 30s
test-sqlite / success	2s
success	1s
	58m 7s

Provide feedback