The law mostly doesn't require it. Only if a crime is suspected, or perhaps in case of accidental death to determine if the accident caused the death or something else happened first (e.g. stroke, heart attack) that lead to the fatal accident (could be very important to determine liability, if any).
But your average old or sick person passing away at home, generally does not get autopsied.
For the same reason we investigate plane crashes, to fucking know what really happened. What is a death certificate without an autopsy is just a scratch on the surface. Sometimes we need to go deeper.