I agree the article and title are terrible. But from what I was able to piece together from three separate articles on the same site:
The police were executing a narcotics search warrant. During the execution, the father of the family (Sistrane Edwards) was shot once and killed. The pet (Unnamed) was also shot and killed. The mother (Cynthia Soileau) was shot and is alive, in the hospital, in critical condition.
Deputy Marshall Barry Giglio was shot and killed, allegedly by the son (Vonteeko Anderson) in the family, who's been arrested for first degree murder + some drug offenses.
Someone else was also arrested but not named or charged.
The father, Sistrane Edwards, is a veteran with 13 years in law enforcement - which is probably why OP's title mentions "two Louisiana cops dead".
Anderson’s sisters say their mother, stepfather, brother, and her brother’s girlfriend had only recently moved into the home where the search warrant was executed.
They say a violent robbery at their previous house forced the family to move there, and they believe that played a factor in what happened Monday night.
This smells of botched paperwork. It wouldn't be the first time a no knock raid caused loss of life because someone didn't bother to double check the address. I'd rather the police not have this in their toolbox. It's too prone to mistakes, qualified immunity means no one is held accountable, and the resulting lawsuits become the tax payer's problem. We need justice, but justice done with due diligence and accountability.