A sensitive question, but do the families of those who die in combat become wealthy from $500K death insurance?

I think the SGLI + death payout adds up to 500,000 dollars for those US service members killed in combat. Generally, what happens to the beneficiaries of those designated by the insurance?
Do they end up wealthy?

---

Orignal From: A sensitive question, but do the families of those who die in combat become wealthy from $500K death insurance?