How big is your library? Mine is about 10,000 songs, which I consider moderately large. Just by mere quantity the task would be very daunting. And I've certainly heard of people with much bigger libraries. I tried rating songs a few times and didn't think about it much and stopped without much thought, but what you're talking about is probably why.
As Bigshot alludes to you can pick out who is better at what in a lot of cases in terms of individuals--writing, singing, their instrument, etc. I can do that pretty easily for my own purposes. In college I was a music minor but I was on the same campus and lived in the same dorm as students from a nationally ranked music school. I ended up taking some classes with the freaky talent music guys [Edit: and gals], on their own turf, including "music appreciation." And the professor would play some garbage 20th century classical music and insist to everyone it was good music and we would all try to hold our laughter. Now in fairness, the same guy could sightread an orchestral score and transpose it for piano (from all of the different kinds of clefs) and play it on piano
in real time.
And on our exams he'd drop a needle on a record for about ten seconds and we had to identify the likely period, the likely composer, the techniques in the music, the likely formal structure of the whole piece, etc. etc. etc. I consider part of my characteristic of being able to still enjoy new music I've never heard or is different from past things I like at this age as being in part because I was exposed to and *tried* to play classical and jazz from a youngish age. The point being, if one person in the music is doing something cool, it's got my attention, whether I think much of the music as a whole or not. Or at least that's what I was going to say the point is even though I was not even thinking of that. So what is the point. "Compressing" music from one to three stars, I've tried it, and yes, I had a similar experience, and I don't know a solution. I will make that my point. But along with it you get a bunch of rambling thoughts and reminiscing.
I will say, however, that Mahler was a better composer than "Weird" Al Yankovich. But I like Weird Al Yankovich too. Mahler, three stars. Weird Al Yankovich, one star. Easy.
My only practical suggestion is if you just plain don't like it make it zero stars. Three stars is a pretty compressed scale to rate music you like anyway.
I will say also that 10,000 songs might seem like a lot, but I've had most of them for years, for decades, and it's really not that much to get my arms around. And sometimes I will make myself listen to something I was disappointed in when I first got it, and I will find I like it a lot.
Since the advent of music streaming, my music purchases have trickled to near nothing. About the only thing I get now is stuff that is absolutely precious to me that is not on a streaming service, or maybe a Sammy Davis, Jr., CD, here and there to learn to listen for artifacts.

The most recent example of something I could not find on a streaming service that I found absolutely precious so I bought a CD of it is Van Morrison's album "Tupelo Honey," just to give you an example.
I've also become extremely skeptical of music critics. As Bigshot alludes too, some of them love to hear themselves write. Totally unlike me, who only writes with great reticence. Or as Frank Zappa described rock journalists:
"People who can't write, doing interviews with people who can't think, in order to prepare articles for people who can't read.”
Now that's a bit much, but it gets the point across.
oh that's how I roll. yum or meh, it's getting beyond that's hard for me. in foobar I've added a rank tag to all my library, it goes from 1 to 3. 1 being stuff I really like(but there is a great deal of 1), 2 being basically, the rest. and 3 are few in numbers like new albums or stuff I never really got into, so I didn't make my mind. and a few times a year, I listen to all the 3s and if I find no reason to promote them in that last chance listening, they get the recycle bin treatment.
but as soon as I try to consider a "best" song, or sorting songs from best to worst, there is just so much choice. sooooooo many songs!!!!!