fix: handle empty HEAD response #7911

Job	Run time
integration-test-s3	1m 12s
integration-test	12m 33s
cibw-dev-env-smoke-test	29s
lint-and-unit-test (3.12)	2m 54s
lint-and-unit-test (3.10)	3m 37s
lint-and-unit-test (3.13)	2m 49s
lint-and-unit-test (3.11)	2m 44s
integration-test-gcs	1m 3s
integration-test-adls	1m 21s
integration-coverage-report	32s
	29m 14s

Provide feedback