coordinator not loading historical data

### Affected Version

0.16.0

### Description
I changed my datasource retention from `P1D` to `P4D`, yet only 1 day of data is loaded and console still says datasource is fully available.
This datasource is over 6 months old so i know older data exists in s3.



i wonder if this is related to #9040 (note that i dont see the datasource `kube-metrics-30m` in the error logs)

The report names no source files, tests, or entry points. Start by reproducing the retention change on the affected Druid datasource and inspect coordinator logs and historical-data loading behavior; the issue does not define a code-level completion condition beyond loading the expected historical data.

Written by the indexing model from the issue text.