ENH: Series.str.get_dummies() raise on string type (follow up to PR #59577)

ENH: Series.str.get_dummies() raise on string type (follow up to PR #59577) #24986