Agreed. Triggers are especially useful for maintaining counts. If you want to feel extra smug, there's a post from Instagram eng about how they realized they should denormalize counts of likes only pretty late in the game.
The basic issue is that derived data should not be included in base relations -- they belong in derived relations, such as views.