The day google maps came out was basically the last day I used mapquest.
I'm pretty sure I switched the day it debuted.
Google Maps was the iPhone of Mapping, and continues to be so. And, much the same way others are pretty good (Bing Maps isn't bad) - they are all still compared to Google Maps.
Apple Maps is the Zune? No, that's not a good comparison, the Zune was a competent technical product. The Kin? Maybe not that bad. Apple maps is the Kindle Fire (original) of Mapping. Starts off kind of crappy, but might turn into something better with a lot of work. People will still want an iPad though.
There is a better product out there, and until yesterday I had easy access to it on my phone and now I don't (sorry I don't like loading up google maps in the browser).
If I had to bet, I'd say Apple won't approve Google Maps native app for a while just to force people into using their Maps hoping we'd get used to it.