How to cancel family sharing
How to transfer kid family sharing account with another family member
Question marked as
Best reply
It has to transfer to someone not in your current family. See the Apple Support article(s) below.
Family Sharing - Transfer a child to a different family group - Apple Support