As of version 2.55.0, Prometheus supports this. From the 2.55.0 changelog`:
2.55.0
[FEATURE] Scraping: Add the ability to set custom http_headers in config. #14817
http_headers
http_headers is documented in the scrape_config docs.
scrape_config