Readers will please forgive me for attempting to speak of the broader trend displayed by this incident. My aim is not to insult the officers putting themselves in harm's way, as they are generally not the people directly responsible for the suboptimal policy. I don't mean to presume that the tactic used in this specific instance wasn't optimal. Perhaps it was, but I would ask you to compare to a realistical second-best alternative. In this specific case, perhaps all of the alternatives were investigated and a high-stakes confrontation was indeed the best way to serve this particular narcotics search warrant.
In the general case, though, it is clear that alternatives to SWAT raids (increasingly "no-knock") for non-violent warrants are generally ignored. I care about officer safety and I care about the safety of citizens that are the targets of these warrants, especially considering the alarmingly-high rate of "wrong door" raids and embarrassingly-low rate at which these SWAT raids uncover criminal behavior. In the early 1980s, police performed ~3k SWAT-style raids. In 2005 (the last year with good data), there were 50k raids.
To the officer safety and potential alternatives end, I think it's instructive to look at what tactics are used in situations where the targets of search warrants are known to be violent and dangerous. For example, in this case where a known violent criminal had a stash of guns, instead of a SWAT raid on his home, they called his cell phone and said that his storage locker had been broken into so that he could be apprehended without incident (http://www.wsj.com/articles/SB10001424052702304791204576402742970279686). I'm very confident that officers smarter than me and with better understanding of specific situations can come up with a myriad of other methods. Effort is worthwhile to avoid putting officers, drug dealers (who are not the brightest of the bunch and are tasked with defending themselves from others of their type), drug users and innocent citizens (35-65% of narcotics warrants result in no contraband) into situations where they must make split-second decisions involving lethal force.
Every time one of those high-stakes situations is converted into a search on an empty house, an arrest in a driveway or is deprioritized entirely, that's one more Officer Jared Francom that gets to go home to his family (https://www.washingtonpost.com/news/the-watch/wp/2014/07/17/internal-documents-show-that-utah-police-did-little-investigation-before-fatal-drug-raid/).
I think that the use of SWAT raids to serve narcotics warrants is unconscionable, that the system that creates those encounters must change and that it will take recognition of that fact from rank and file police and from ordinary voters in order to reduce the potential for tragedy that they cause.