Playing the Devil's Advocate here.
I used to work for a major label, back when streaming was really taking over and people were starting to pay for premium. I don't know what the royalties from the likes of Spotify are now, but back then they were pretty close to the levels from that website linked above. But what the artist got paid varied with the deal with the label, who of course keeps some of it. The label was at the time just coming to terms with how to economize this new medium. This was around 2014-2015, so they had just started to embrace it.
What many seem to forget, including some artists, is that with streaming artists get a continuous stream of payments for as long as the song gets played. Before streaming, both artists and their label would get paid handsomely in the first few months after the release of new music. But probably around 80% of sales of an album was in the first week, or so. So, they'd get one or two fucking massive checks, but when all their fans had purchased the album/single, the royalties would dry up until the next release.
Streaming, don't forget, was a massive worry for the labels as well a few years back. But they realized these economics and have instead focused on continuing making money from their catalogue. I mean, artists like Rod Stewart or The Monkees (don't ask me why these two came to mind first) or even artists like Prince weren't exactly cash-cows in 2008. All their fans already owned their popular material, or downloaded it for free, illegally.
Both Rod Stewart and Prince has around 9 millions unique listeners a month now (presumably streaming their songs more than once). So, we're talking many millions of streams each month. I'm sure Rod Stewart makes more of his catalogue in a few months today, than the release of his n:th album in 2007. His label certainly does, anyway. In short. Make memorable music and you'll earn pretty good money over the lifetime of your work. Mediocre artists, whether you define it in terms of hit potential or in terms of artistic quality, weren't getting rich back in the 90s either.
I will say though, as I really don't want to defend the major labels of the music industry, that while Spotify aren't paying huge numbers for each stream, you got to remember that the labels are still taking a pretty hefty part of whatever number Spotify mentions (or the numbers from that website above). Before streaming, they could motivate it by being the only ones able to mass-produce and mass-market physical records. Now, since the cost of reproduction is essentially zero and you instantly reach all markets once you post your song, they're taking a huge cut for basically posting a few Instagram-posts as marketing and lobbying Spotify to put it in their playlists.