Is pianists' a plural possessive noun?

Yes, the Word pianists is the plural form; the Word pianists' is the plural possessive form. Example:

The pianists' rehearsal is scheduled for Wednesday.