Update prometheus and thanos version to latest main (#6025) #9202

Job	Run time
build	4m 18s
lint	16m 34s
CodeQL	6m 29s
test	18m 0s
integration-configs-db	2m 11s
integration (requires_docker)	5m 42s
integration (integration_alertmanager)	4m 3s
integration (integration_backward_compatibility)	8m 38s
integration (integration_memberlist)	8m 7s
integration (integration_querier)	11m 44s
integration (integration_ruler)	4m 23s
integration (integration_query_fuzz)	2m 29s
deploy_website	1m 45s
deploy	2m 16s
	1h 36m 39s

Provide feedback