We all believe that our children will automatically go to our family to be cared for when we die. However if one parent dies, normally the other parent will carry on looking after the children. There can be circumstances where this may not happen such as the remaining parent not being suitable to have the children.
If both parents are deceased then the children will be taken into care by Social Services unless you have made provision for Guardians in a will.