The money is there as long as you remain local in your programming.
Of course, you can't rely on that to support a station. In most small towns, there are plenty of Mom and Pop locally owned businesses. The local Chamber of Commerce is very active here and line up local businesses to sponsor their radio show. The Chamber in turn sends out email blasts encouraging members to support those sponsors and it works.
The problem is those small local businesses simply can't afford radio. That's driven spot rate way down from what it used to be. The local restaurant can afford a few spots, but the radio station wants them to buy a full plan. People mostly listen for short periods, so advertisers need to buy hundreds of spots, and they can't afford it. Doing local sports is great, but it's also expensive to staff and broadcast. I've heard some stations keeping costs down by doing the game on the telephone. That may work on a small AM, but sounds horrible on FM.
I think by now you've grasped the theme of my posts. Local Radio as we know it has pretty much died and it's sad.
Local everything is going away. The big box stores are shutting down because of online shopping. Those online stores don't buy local radio. You brought up Pandora and Apple. Where's the local content there? People seem to enjoy it regardless. Maybe all this emphasis on local isn't what people really want. At the end of the day, local costs money. If the people have gone online and aren't buying local, it also kills local media. I know you don't see it this way, but the people are the ones who are killing localism.