Using bitcoin for currency as a whole (IMO) is almost like a misguided application rewrite -- sure, at the beginning it has all these advantages of being light and nimble and having limitless possibility, but by the time you add all the stuff users actually want/need back into the system you wind up pretty much right back where you started with the old heavy app, perhaps with a shift of power behind the scenes (from the old architect to the new architect, if those are different parties), but nebulous real advantages for end users at the end with a lot of transitional pain in between.
3rd party wallets do not provide security via black magic. They use tools like passwords, 2FA, and email addresses, all of which could be compromised on a user's computer. Think key loggers, viruses, social engineering, people leaving their computers unattended with the wallet open.
There is no technical reason why the security measures that Coinbase implements cannot be done using a personal wallet. Moreover, when storing coins on Coinbaes, you are additionally subject to counter party risk (Coinbase goes under, loses their coins) as well as regulatory risk (Coinbase shuts down withdrawals due to regulations).
Yes, they use passwords, 2FA, and email addresses, but those are all things mainstream users are familiar with and have to use for any other major service. They are not familiar with the concept of encrypting a wallet or the fact that deleting a wallet can lose you money.
Of course you are at risk of something bad happening to Coinbase, but steps like getting insurance are hedges against that. I should point out that when I talk about mainstream users, I'm not so much talking about right now, but in potentially a few years when Coinbase is more of a known institution or existing banks or other parties have jumped into the game. At that point a wallet hosted by Google or something will be a much better bet for most consumers.