I drilled into the literacy reports cited by [1], eventually landing at [3]. From those results, the US is not especially anomalous compared to other countries, although breaking down by nativity does suggest that the US has an anomalously large gap between native-born adults and immigrant adults.
The UNESCO rankings and the PIAAC rankings give substantially different results by observing scores. There's a few countries in both: Chile, Cyprus, Estonia, Greece, Italy, Lithuania, Poland, Singapore, Slovakia, Slovenia, Spain, and Turkey. Most of those countries are given >99% literacy rates by UNESCO, but have a few percent classified as "Below Level 1" by PIAAC, indicating that UNESCO has a much looser definition than PIAAC.
I can't tell you which ranking is better correlated to what a naïve observer would think of as "literate," but the two rankings are definitely measuring different things.
[3] https://nces.ed.gov/surveys/piaac/ideuspiaac/report.aspx?p=3...