Interesting to look at the population from your link. The United States appears to be doing the best (LPI 2020 ranked 18) out of all the countries with population over 100 million. After Japan (ranked 19) the next closest are China (54) and Indonesia (57). I'm not sure what relevance this might have, I just found it interesting. The CEO rankings show a much different picture.
If I had to guess, one is weighting access to care differently than the other. America's system is good but not top tier if you can get it. It's really bad if you can't.