By the sounds of it sort_name is a text field. orderby=meta_value_num WP converts the text field to a number so they all == 0. WP then sorts them by the default order which is by post date. try orderby=meta_value.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users