I was hoping that the information I provided would help you find the information you needed. The database query that you’re doing will not get what you want.
You’re going to have to do another query of the postmeta table using each of the ID values in the array. I think that you can query the meta_key _wp_attachment_metadata. This will give you another serialized array and this array will contain the urls for each of the different image sizes. Then you’ll need to extract what you want from there.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users