I believe that Facebook will keep being somewhat interesting by default due to their alluring ecosystem and viral potential for future entrepreneurs. Most new Apps are built with a clear strategy of broadcasting itself (and showing some of its features) through Facebook feeds. These new Apps have made peoples feeds a lot more interesting. I think Instagram is a good example of this. It made your friends amateur photos much cooler and aesthetically pleasing to look at; thus drawing you to a more interesting Facebook experience.
Their strength lies in their ecosystem and ability to let their users and developers easily create and share content. They have more or less nailed this down already (along with a revenue sharing system to sustain some of their infrastructure costs). At the end of the day, even if they stopped innovating, they’ve done such a fantastic play with their infrastructure, that it ensures that they remain interesting as long as new entrepreneurs keep developing Apps that enhance their ecosystem.
If anything, I think their need to copy and catch up with new breakthroughs from other social networks (i.e. Google+, Foursquare and Twitter) is actually making their product more convoluted and less appealing. Less is more in Facebook’s case. That was the genius of Facebook from day 1. You could strip down Facebook to probably 5 core features and it would still remain relevant and interesting because of others ability (developers and friends) urge to create and share.
Until someone is a better social networking site than Facebook, they are in no danger of "becoming Yahoo." And I don't think that's going to happen anytime soon - and maybe not ever. Facebook may become "boring," but only in the sense that all of your utilities are boring. You rely on them, but they cease to be exciting, and instead just become part of the background of things that you take for granted. This is very different from Yahoo, which is boring because it's irrelevant.