Exactly.
Police believe themselves to be at war. Not with one-off groups of armed bank robbers, per se, but with heavily militarized cartels and street gangs like MS-13. If an ordinary police unit knocked on the door of an MS-13 safe house, they'd probably be met with heavily armed resistance.
The problems here are numerous. First, because this was not a cartel safe house, and any degree of diligence sufficient to obtain a no-knock warrant should have made that clear -- which means that either the diligence process is broken, or it was subverted. Second, because very few houses in residential neighborhoods are gang hideouts, and the police are using the theoretical presence of armed gangs as broad, categorical pretext to militarize all of their SOPs, regardless of context, circumstance, degree of escalation, or suspicion of crime. Third, because the level of police militarization in general is growing alarmingly. You'd be hard-pressed to draw a clear distinction, either in armaments or in operational charter, between some of the most heavily armed SWAT teams in this country and small military units.
Stories like this one are not only outrageous; they are horrifying. I don't want to subject myself to recency or memorability bias. But I'd be very curious to see the stats on how many of these incidents are occurring for every SWAT operation that, say, takes down a real bad guy. I'm not in favor of banning SWAT operations altogether, so much as I'm of the strong belief that the "S" in SWAT should always stand for "Special." As in, we've been building a legitimate case for months on this location, and we have extraordinary reason to believe that extraordinary measures are called for.