You cannot get a list of one post type ordered by a value of another post type. This is not possible use WP_Query.
To do this any value you want to order by must be a value for the posts that you want to order.
What this means is that when you save a post you must use an acf/save_post action to copy the values you want to be able to order by from the other post type and save it as a meta value for the post being saved.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
2022 was a big year for Advanced Custom Fields, with more capabilities, a new generation of ACF Blocks, a refreshed UI, and a new home. Our year in review post looks at advancements we’ve made and offers a glimpse of the future. https://t.co/HahJUCcyH4