Nothing will change. There is a mass group of gamers that seem to only move from the newest thing to the next thing. After a month or two we'll see the numbers drop by 50%
Yeah, I mean, no shit. It's prevalently a single player game. There will be a bunch of very dedicate users who will stick around and replay it over and over, but for the most part people will just move on to the next thing after one full playthrough, when even that.
This should be in NO way be considered as a factor that discredits the quality of the game.
That said, I'll take the chance to point that this Sunday the game broke a new record of concurrent users: 875,343.
The mere fact that it climbed even higher after the first weekend (which is typically when most single player games peak, only to fade away over time) is impressive in itself.