How to cancel family sharing
How to transfer kid family sharing account with another family member
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