You can be great at what you do without being popular, especially when how popular you are is based on the opinion of an extremely divided population that's influenced by media that try to make people angry at anything and everything to generate more clicks so they sell more ads.
That's why we listen to the opinions of experts, not random Joes. Just go to a townhall meeting to listen to the average person and their take on what cities should do.
Its a list based on personal opinions of “greatness” not accomplishments
The primary purpose of this survey was to create a ranking of presidential greatness that
covered all presidents from George Washington to Joe Biden. To do this, we asked respondents to rate each president on a scale of 0-100 for their overall greatness, with 0=failure, 50=average, and 100=great. We then averaged the ratings for each president and ranked them from highest average
to lowest
You can be great at what you do without being popular
You absolutely can, but Biden is neither.
Unless of course you take the cynical (read: realistic) view that his real job isn't to govern well, but to please his owner donors without losing too much support from regular people..in which case he still isn't great but goes from awful to just slightly worse than required.