It's still going to be a chicken and egg thing - it's not just the Major apps. It's the apps people use from companies like USAA, your local credit union or bank, your grocery store, your sports team (How many team apps are there for any of the major sports - MLB, NFL, NBA, NHL - right now I think the answer is none. As long as Windows Phone lingers at 3-5% the use base is not large enough for these corporations to spend money to build and support an app for this platform. I would be lost without my banking, grocery (user loyalty), and sports apps on my phone. From this perspective, the app story on Windows Phone has not changed at all. I'm guessing there aren't a lot of sports fans here that follow their home town team long distance.
IT's getting better, no question. I use Bank of America...Yep there is an App for that. I am a Huge Boston Red Sox fan, no MLB app but, a great ESPN hub (Nokia) and even my favorte sports radio station has an app for WP (WEEI 103.7). Plus there is a bunch of great games coming out now (modern combat, Spyder man, batman, etc).
As it's not perfect by any means, I forced my wfie to use her upgrade to get a 928. She seemed to love the tiles and the OS itself but, due to many limits on the apps that she uses day to day, she ended up returning it because the apps just would not do it (Shutterfly app was the largest, she uploads all her pictures with it and with the app, you could only upload 1 picture at a time, the iOS you could upload 100's at a time)
There is lot still to be desired for Windows Phone apps, but, as the marketshare grows and the time goes in, it will get better. The sad thing is just needs time and this is something we need now, not 5 years later...