I didn't realize that Titanfall was an only-multiplayer game. Maybe I haven't done enough research on the subject but, with all the cutscenes and so forth, it certainly appeared to at least have a singleplayer component. If it truly is multiplayer-only, I may have to rethink my investment.
As for the multiplayer vs. DRM argument: I certainly see the the argument that always-online components equate to an unspoken DRM, and I can't say that I disagree with it entirely, but I think there's a very intrinsic difference between utilizing an online connection to create multiplayer content to requiring an online connection in order to play the game. It's just broken down into whether the online connection is 100% necessary or not.
In the case of Destiny, there is no defense; the developers have already stated that the game will need an internet connection in order to be played. Reference: http://www.computerandvideogam...
Same story with The Division: http://www.playstationlifestyl...
Though people could split hairs and say that the online connection is necessary just to access the content, not to check if you have the rights to play the game, it equates to the same thing: without the internet, you aren't playing either game. Which, really, is a crying shame.
There are exceptions, though. Watch_Dogs utilizes an online connection with subtle multiplayer aspects but does not necessitate such a connection in order to play.
That's the industry we're in these days, it seems. Gamers put more and more emphasis on multiplayer so developers are looking for new and interesting ways to deliver an experience that is equal parts multiplayer experience and story-driven campaign. Despite the outcry from us vocal minority folks (which I suppose is the sad reality of the issue), people are yelling in dollar bills that they approve of the industry's new standard. It's a crying shame, really, because it's sending innovation in a very particular direction that not everyone enjoys.
It's nice that there are still some devs who appreciate the more personal experiences, though. The Last of Us delivered an amazing performance, regardless of what people thought of the gameplay, and games like Beyond: Two Souls and Transistor look to deliver interesting and compelling singleplayer experiences. (Say what you will about Quantic Dream, they create great performances in their games.) It's just a shame that they are so few and far between these days.