test: remove dependency on uncommitted .env file in project root

Five tests were referencing PROJECT_DIR/.env (which is gitignored) and
failing in CI with "Environment file `.env` does not exist". Each test
now creates its own fixture file via tmp_path. The redundant
test_root_env_duplicate_key_warning (identical coverage to
test_duplicate_key_warning_message) is removed.
