Yup. ARTIST_ID does not have a 1:1 relationship with ARTIST_NAME over time.

Another example... from 1976 to present day: Johnny Cougar → John Cougar → John Cougar Mellencamp → John Mellencamp.

Close enough for library software to store/recall them all as "John Mellencamp"? Maybe. But perhaps not to fans or historian or artist liking.