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.