Improve lockfile management documentation and enforce `uv.lock` fresh… #7992

Job	Run time
cibw-dev-env-smoke-test	27s
lint-and-unit-test (3.10)	2m 57s
lint-and-unit-test (3.12)	2m 45s
lint-and-unit-test (3.11)	3m 0s
integration-test	10m 31s
integration-test-gcs	1m 18s
integration-test-adls	1m 27s
lint-and-unit-test (3.13)	2m 48s
integration-test-s3	1m 14s
integration-coverage-report	33s
	27m 0s

Provide feedback