Outbound sales teams that run HubSpot Sales Hub as the CRM and need a contact database, enrichment, and sequencing.
Apollo's own HubSpot page puts it plainly: Apollo finds leads, HubSpot works them. Neither replaces the other.
If you're mostly inbound, the enrichment piece may be all you need.