Open health app and press on your profile picture in the upper right corner (scroll to the top). Then scroll down and press export all health data. Also OP mentioned the exported XML has some errors in iOS 16, so beware of that.