If you know anything about Neil Young, he doesn't really seem to care about money that much. I mean, he could've kept recording albums that sounded like Harvest, but he likes to mix it up. Hell, he's recorded everything from porto-industrial noise to blues, jazz, country, grunge and even cover albums.
Plus, Spotify pays peanuts. Now, as an established artist, he probably made a few thousand bucks a month (possibly more).
As for Rogan, he is peddling misinformation and it is actually dangerous. Think of all the people on this board and around the world who listen to him move goal posts and tells falsehoods about the safety of the vaccine. He could literally convincing people to do things that will get them killed. Now, I'm not surprised Spotify chose Rogan. They paid him a buttload for the exclusive rights to the podcast. He is popular. Neil has legion of fans, but they are older and probably don't subscribe to streaming services.
But I respect Neil Young a hell of a lot more than Rogan. Neil has always put his money where his mouth is. He helped launch Farm Aid, written protests songs and refused to allow his music to be used in commercials and for political purposes. Lord knows he could make a ton if he reversed this.