From my experience Google Maps is the superior product. The only reason I kept using Apple Maps was because I wasn’t molested with ads.
Now that this will obviously change, why should I keep using Apple Maps? At least they should have kept it ad-free for people already paying a premium for their Apple One Premium subscription.
I have less and less incentives to stay in the Apple ecosystem, this is just another nail in the coffin.
Depends what you're looking for. If I'm looking for businesses or streetview or 3D I'll use Google Maps. If I want to explore I'll use openstreetmap. Sometimes I'll use public rights of way mapping or parking zone boundaries on local council websites, or hiking-specific mapping apps that overlay routes. Having one mapping app that does it all would be nice, but each serves their purpose