Campaign Red’s latest report reveals how AI investments are transforming ad agencies but raising tough questions about costs and profit.