Any monkey can bang out code
You have already failed. True anyone can write some bug riddled piece of dog snot. But programming and development is a creative endeavor. AKA an art. Jut as my kid can knock out a stick figure in art class, it does not make his work a Rembrandt. Sure it's art and "anyone can bang out art" but when I go and try to sell my child's art as a masterpiece, well we both know what the revenues are going to look like.
You already have a respect for the profession that is going to put you at odds with the kind of people that you would need, to get you anywhere further than a failed project. These people don't need you or your idea. They are creative they have plenty of their own projects and they respect their craft and only work with others that respect their craft.
As for the idea thing, it is worthless absolutely worthless, you need to understand that first and foremost. Great ideas fail in the market place for all kinds of reasons, it does not guarantee success. So you have to ask yourself what I am going to contribute and you need to be able to communicate that to a perspective partner.
You need to be able to say, hey I have this great idea for a product. I can't write code, but I am great at sales and marketing or accounting or business development or X. Or you need to be able to say, actually I can't do anything but I am going to bankroll the whole thing. Those are valid but if all you have is an idea and you want someone else to put in the sweat to bring your idea to life while you sit back and come up with ideas, well then you are SOL.