No; the Catholic Church does not believe that confession by itself is sufficient to ensure forgiveness of sins.
The Catholic Church believes that God alone forgives sins, but has delegated that authority to certain human beings within the Church (cf. John 20:21-23).
God is "gracious and merciful, slow to anger and abounding in mercy" (see Psalm 145); he is also "abounding in steadfast love, and relenting in punishment" (cf. Joel 2:13). Nevertheless, there are three conditions which (except in extraordinary circumstances) the Church believes are required to ensure forgiveness of one's serious sins: confession, contrition, and satisfaction (or penance).
"Penance requires... the sinner to endure all things willingly, be contrite of heart, confess with the lips, and practice complete humility and fruitful satisfaction."
(Catechism of the Catholic Church, paragraph 1450; quoting the Roman Catechism)
Let's take these one at a time.
Confession
This is the practice of telling the priest the sins you have committed since your last Confession. Catholics are required to go to Confession at least once a year; more often is better (and makes it easier to remember what sins you've committed!).
Confession should be preceded by an examination of conscience, in which one thoroughly and frankly looks at one's behavior—one's thoughts, words, and deeds—in light of Christ's commandments. Any serious sins that you remember must be confessed. If after a sincere examination you forget a serious sin (and, for example, remember it only after confession), there is no need to worry about whether you are forgiven—but if you deliberately leave out a serious sin, you are lying (by omission) not only to the priest but to the Lord. This is itself a serious sin. It appears that such an omission invalidates the entire confession; at least that's my understanding of a statement given by the Council of Trent, and quoted in paragraph 1456 of the Catechism:
When Christ’s faithful strive to confess all the sins that they can remember, they undoubtedly place all of them before the divine mercy for pardon. But those who fail to do so and knowingly withhold some, place nothing before the divine goodness for remission through the mediation of the priest, "for if the sick person is too ashamed to show his wound to the doctor, the medicine cannot heal what it does not know."
Contrition
The Catholic Church has a very specific understanding of contrition, and the Council of Trent developed a valuable distinction between what it called perfect contrition and what it called imperfect contrition or attrition; but essentially, contrition is an intense, sincere sorrow for—perhaps even a hatred of—one's own sinful behavior, together with a sincere resolution to avoid sin again.
This, it seems, addresses the problem you bring up. If someone sins Monday through Saturday, and goes to Confession Sunday with sincere sorrow and the sincere intent not to sin again, he's all good, even if he does in fact sin again on Monday. But if he goes to Confession not caring whether he sins on Monday (or perhaps even planning to), he is not showing a desire to be reconciled with God; he does not turn again toward God, and we cannot say that he is forgiven.
Satisfaction (Penance)
Many sins wrong our neighbor. One must do what is possible in order to repair the harm (e.g., return stolen goods, restore the reputation of someone slandered, pay compensation for injuries). Simple justice requires as much. But sin also injures and weakens the sinner himself, as well as his relationships with God and neighbor. Absolution takes away sin, but it does not remedy all the disorders sin has caused. Raised up from sin, the sinner must still recover his full spiritual health by doing something more to make amends for the sin: he must "make satisfaction for" or "expiate" his sins. This satisfaction is also called "penance."
(Catechism, paragraph 1459)
Penance, or satisfaction, involves spiritual and temporal works designed to restore relationships broken and damaged by sin. The Catechism says that penance
can consist of prayer, an offering, works of mercy, service of neighbor, voluntary self-denial, sacrifices, and above all the patient acceptance of the cross we must bear. Such penances help configure us to Christ, who alone expiated our sins once for all. They allow us to become co-heirs with the risen Christ, "provided we suffer with him."
The satisfaction that we make for our sins, however, is not so much ours as though it were not done through Jesus Christ. We who can do nothing ourselves, as if just by ourselves, can do all things with the cooperation of "him who strengthens" us. Thus man has nothing of which to boast, but all our boasting is in Christ... in whom we make satisfaction by bringing forth "fruits that befit repentance." These fruits have their efficacy from him, by him they are offered to the Father, and through him they are accepted by the Father.
(paragraph 1460; the quoted material is from the Council of Trent.)
As the Catechism says elsewhere, God is not bound by his sacraments, and He can forgive even outside the context given here; but this is what the Church believes to be required, under ordinary circumstances, to ensure that sins are forgiven. The simple act of telling one's sins to a priest and having the priest recite the formula of absolution1 will not do.
1Here, if you are interested, is the formula:
God, the Father of mercies,
through the death and resurrection of his Son
has reconciled the world to himself
and sent the Holy Spirit among us for the forgiveness of sins;
through the ministry of the Church
may God give you pardon and peace,
and I absolve you from your sins
in the name of the Father,
and of the Son,
and of the Holy Spirit.