Make a joyful noise unto the Lord...
He means for us to be on earth to be obedient, thankful and useful. In the Proverbs, and elsewhere, there are many practical pieces of the successful-living puzzle.
The main point that shows name it/claim it to be in error is when their teachers try to coax us into emulating God by speaking things into existence. It is what the serpent suggested to Eve, as a matter of fact.
God DOES have an economy of multiplication; but we kid ourselves if we even for a moment think we have God on a string. He calls the shots; and miracles do happen; but it’s His sovereignty and purposes that bring them about — not our words.
The idea, however, that we are looking for wealth and prosperity instead of spiritual riches simply goes contrary to what Christ taught:
Mat 6:19-21 Lay not up for yourselves treasures upon earth, where moth and rust doth corrupt, and where thieves break through and steal: (20) But lay up for yourselves treasures in heaven, where neither moth nor rust doth corrupt, and where thieves do not break through nor steal: (21) For where your treasure is, there will your heart be also.