A policeman is being comforted by relatives after the bodies of his heavily-pregnant wife and son were found at the family home.