When I was an MP (military police), they taught us a bit about
escalation, wherein you only use what is necessary for the task at hand and reevaluate as the situation changes.
Cops certainly do not need to be using 'weapons that belong on the battlefield' as their go-to weapon for any raid unless it is suspected that there may be body armored opposition (an absurdly rare occurrence - worth treating as an outlier). It would not be unreasonable to have one or two rifles on standby, in case a situation escalates beyond what was expected.
I do not like this trend of increasing para militarization of the US police forces. You are supposed to trust a police officer. It is hard to trust someone wearing BDUs and carrying assault weapons - you are more likely to respond fearfully, which can often make things worse.