Clickbait title.
RPi used to be $25 or $35 , and then use equipment lying around.
Now it's $80, plus high performance power, case, active cooling, storage, etc.
RPi is no longer in it's own original category. And when you compare via cost, it's a loser these days.
The only way the RPI isn't a complete loser is inertia, pure and simple.
If you are interested in a Pi that is in their original category, there are options available.
The advantage of the Raspberry Pi is the software. Raspbian just works and will continue to work. Other SBC might not work with their software and who knows if it will ever be updated. My understanding is that there are stable OSes for other boards, but then have to find boards that work.
I recently got Pi5 to use as computer, and microPC is probably better for that. But the Pi can be repurposed for other uses. I'm pretty sure I can pull the microSD card from Pi4 and put in Pi5 and it will just work. The Pi4, which is an awful computer, will do some thing that microPC can't possibly do.
I was looking at Adafruit where I could have bought all of them for the official prices. But can't buy more than 2 though. The same seems to be true of the UK and EU shops I checked.
I mean the title is withholding information and wants us to click on it.
Maybe the "Pi 5 is still an odd fit for day-to-day desktop use; cheap mini PCs come closer" subtitle would have been better.