Does Roll-Up Reporting work in the Intranet?

Yes, Roll-Up Reporting works with Matomo (Piwik) Intranet Analytics when you self host Matomo on premise.

Previous FAQ: Does Roll-Up Reporting show aggregated data of all of my websites?