I wouldn't use Cork or Limerick as examples of the positive implications of name changes.
Cork has had about twelve different clubs in the last 90-odd years, and it ended badly for almost all of them ! Limerick's had a few as well.
Successful clubs tend not to change name.