Sorting posts by custom field value in array

Sadly you can’t.

You can’t query based on serialized data and since you store the data in an array it is saved as serialized.

you should use a separate row for each field you want to query / sort based on.

I asked this same question about two years ago.