Still a Bleak out look??

I continue to go through Ecclesiastes. It still does not sound very uplifting. Chapter 9 talks about a common destiny for all. At first pass, this sounds like there is no point in righteousness or wisdom in life at all. Either Solomon is very disillusioned as to the whole point of life, or he is trying to make the point that what you have, or who you are in this life doesn't matter. Is there sarcasm here? Yet, the author explicitly states that no one can comprehend anything that goes on under the sun (8:16-17). This tells me that we cannot know the purpose of life. Both wise and unwise have the same destiny, but wisdom is still held up as the better value here.