From an investment perspective: a good SIP makes money for you, likely in the double digit percentages over long a period.. An LIC life insurance policy will yield in low single digit percentages (almost similar to a bank deposit) and make money for the insurer.
From a protection of family perspective only (not as investments), an LIC policy is good only if its a term life policy.