Unless specifically excluded as a cause of death in your policy, life insurance would provide coverage and a death benefit payout if you died as a result of a DUI. Whether you died because you were hit by a drunk driver, you were a passenger in a vehicle driven by a drunk driver, or you caused the accident due to drinking too much, it may be covered.
However, you should ask the insurance company and/or your insurance agent how a specific insurance company would address the particular cause of death in question.
Here's how you can learn about life insurance for drivers with a DUI or DWI.