What should I do now? Change my niche?

So.....this is how I am feeling right now. Like that guy with his hands covering his face. All I keep thinking is.....What should I do now?

OK....let me back up. I casually mentioned to Kyle in a post that I was feeling a little down because...well...maybe I needed some encouragement regarding my selection for a niche.

I decided on my niche because someone *in one of the top spots* on WA actually told me that it was a great idea. They supported my idea. So...now...I don't get it. After posting my comment...I received a post back from Kyle mentioning that I should change my niche because it is too broad.

Saying that I feel devastated is an understatement. I have spent hundreds of hours at the computer already. Do I abandon my site and all my hard work?

Kyle says to narrow my niche to....maybe...organic soaps. Again...I felt like someone popped my balloon. I thought that I had great purpose to help others with my site. I knew what products that I would like to offer. But, why bother sticking with this niche....if I am simply not going to make any money?

So...now...here is where I need your help. Without taking down my whole website and starting over....(and this thought makes me sick after all the work that I have done.) Who has a clever idea of what I can do with my site without totally dismantling the whole site?

Any and all feedback...comments...and suggestions are very kindly appreciated.

Thank you very much....(sad and somewhat confused) *Melanie*