I thought this was sort of deliberate for Apple Health.

People use it to track sensitive information, like reproductive and mental health data, that should only be exported very intentionally.

Agreed. I'm fine jumping through a couple hoops to get my own data in this case.