Yes! This is one of my biggest desires in HomeKit, and the native Home app. Having access to historical data. This is one of the main reasons I have Home Assistant running. I don't use it for any automations, but I do often use it to reference historical data.

I'm not sure how Apple would approach this though. Would it be part of your iCloud data and require a minimum plan (similar to how HKSV operates). I don't ever see them allowing the option to control /where/ that data is stored exactly.