Life insurance is, at its core, a financial agreement. You pay regular premiums to an insurer; in exchange, the insurer promises to pay a lump sum — the death benefit — to the people you choose if you pass away while the policy is in force.
The purpose isn't to make anyone rich. It's to replace the income, caregiving, or financial support you'd otherwise provide, so the people who rely on you don't have to rebuild their lives from a shortfall.
How much it costs, how long it lasts, and what it leaves behind depends almost entirely on the type of policy you choose and the health profile you bring to underwriting.