As of right now, the beta-test is free. They will take your CCN, but will not charge you. Once the game releases, it will cost $50 to buy, then $10 per month to play.
Before I got rid of my sims game, I trapped my wife in the bathroom and built a wall around the door to trap her. After a few days, she croaked. During that time, I was macking with the neighbor girl! It was fun for about a week. Then I just got bored.