Why do they need consoling? Since most people are religious, tell them it's "God's will", and who are they to argue with "god". They should feel "blessed" that "god" has paid attention to them.
For the intelligent minority of non-believers, a miscarriage means that they dodged the bullet of an unwanted child and/or having a defective child. Tell them they are lucky.