I think unfortunately, this is a limitation of the WP_Query object. For WP to order the posts, each post must have a value in the meta field ‘complete’. If no value is found, the SQL won’t run correctly for that post.
Perhaps there are some resources on Google that show how to use a default meta value for posts that don’t have a value?
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users