that's not a fair comparison because pc has people who running on hardware worse than a ps3.

This is a benefit of using PC, not a downside. Unlike consoles, you aren't forced to upgrade every few years and you actually have the ability to change graphics settings. Even if you want to upgrade your PC, you don't need to get an entirely new build.

That's also missing the fact that plenty of people don't need or want to play the latest AAA title.

I mostly take issue with the smug tone of the article acting like it’s over for consoles just because they didn’t meet expectations and decided to bring some games to pc. Consoles are still extremely popular and far more powerful than the average pc according to steam hardware survey. They will still be around and successful no doubt about it.

I agree with you here. These articles are stupid telling people it would be over for consoles. It's just clickbait or they are uninformed. Maybe besides your point that the "average pc" is that weak as you say. Most are at a level of PS4 or stronger. But that is not all you need to compare if you want to an analysis. This topic is extremely complicated. You can't just take the average. There are far more PC users than console players. Its like taking the Game Boy into account and saying that the average game consoles is weak. That's not the full story.

In example most monthly active users on consoles play games that could be played on a potato PC or last gen consoles too and these people probably do not buy newest games. Similar to the situation on PC.