The alphabetic order seems to be out of order there many albuns and as well in artist list that do no follow the alphabetic order
There are album and artist sort strings. Sadly Roon doesn’t show / let you edit them - but “The Beatles” gets sorted as “Beatles, The” and “The Very Best Of …” likely as “Very Best Of …, The”. It’s hard to tell if this or something else is your issue without you showing what you see. You can post screenshots here if still needed.
Update: There is also a “Last name | First name” sort order preference for artists and composers in