... if you can't afford an internet connection then why are you paying for a game that costs upward $40.00?
It's not necessarily about not being able to afford a connection. I've read plenty of posts by players mentioning that their game computer is not connected to the internet, probably for security reasons. But that choice is about to be taken away from them if they want to play Civ 5. And some people get internet access through their work, so they have no need for a home connection. And some people simply have no use for the Internet and aren't interested in having a connection, yet still might play a few games now and then. There's more of those than you may realize.
I don't see the big deal at all, plus if you don't like it there are alternatives.
Not if we want to play Civ 5 there's isn't. That's the whole point.