The country music institution has made some curious picks for membership in the past, but in choosing one of Nashville's most beloved and talented players, the Opry gets it right