The TWI devs have stated that the SP won't just be MP maps with bots, and that there will be more.
Indeed, though that will still exist i belive, as in there will be a "practice mode" where you can just play the MP maps against bots if you want (which is what they have been using when showcasing the game at conventions, so that's obviously there, we've seen it).
The SP Campaign will be something else though, it won't just be the practice mode, but we have allmost no details about it, TWI wants to reveal it at a later date, and have been tight lipped about it thus far.
A few things we do know, however:
There will be 2 campaigns, IE, you can play it from either side, as Russian or German.
The campaign will use the same maps as the MP, or possibly slightly altered versions of them, which means it will take place in Stalingrad, and we can expect that we will be fighting from one end of the city to the next, possibly with a tank map somewhere in there.
There is no one protagonist, RO is a game where you can die from a single bullet, and there's no health-regen, so it would be neigh impossible to do it that way.
Instead we will be following a squad and not a single soldier, and if you die, you will take over another soldier of that squad. But if the whole squad is wiped out, it's game over.
But there's much more we don't know, of course, so we'll just have to wait and see.
But on the face of it, i think we can expect the SP campaign to play more like the Campaigns from the old Rainbow-6 and SWAT games, and not so much like the Call of Duty games.
That's just an educated guess though, not cold hard fact, so take it with a grain of salt.