Your account and every child only you have are removed. Children shared with another grown-up stay with them.
Cancel your Apple subscription separately in your iPhone's Settings — closing the account here cannot reach into Apple's billing.
The full detail is in the privacy policy.