I did see the German police with assault rifles during a protest when I lived in Frankfurt. They may have just been rubber bullets or not loaded etc. I never stopped to ask because it was a little scary coming from a country where you just don't see guns.

That being said, I have no idea about how they police football games, so you may well be right!