Weird Al writes his songs with the permission of the artists. It takes quite a snowflake to get offended at that.
And most of the artists love it.
If your song is big enough for the Weird Al treatment you’re making good coin.