Will Joe Rogan's past send Spotify's subscribers to Apple Music?

Some of them, probably. But it's also more publicity for Rogan, who will attract more listeners (there are millions) who enjoy his brand of humor.