Dealing with your points in order
This website is dead? - Not if you look into the stats over the increased number of people signing up for the Pro service.
SEO is dead? - I must hear that at least once a fortnight but have been hearing it for 4 years and its still here, I'm getting paid by a global company to work in-house on their sites as well as working freelance for local businesses and have got results via SEO so can't agree with you on this one.
If you only have one keyword in the top 50 then you probably haven't done everything possible. Could it be that you don't really know what you are doing so your results aren't matching expectations? Sorry if that seems harsh but signing up to SEO Moz pro doesn't make you an instant expert.
Regarding the new Q&A system - I like it, I can still ask a private question to one of the experts or I can put a question out there for the collective minds of a few SEO's to provide answers. Often in SEO there is more than one way and more than one answer so its interesting to get a range of opinions. I also get to help others with their SEO issues which is something I enjoy doing.
It sounds like you are annoyed as you spent ages writing 500 articles and got nowhere and haven't realised that this probably isn't the best strategy. You say you have spent thousands of dollars but for that you could have employed a decent SEO consultant to help you.
You sound annoyed that Rand is making lots of money....sounds like jealousy to me. If he is then well done to him. He and his colleagues provide lots of interesting actionable insight that have helped a number of SEO's help their clients. Should they give both this and the software aware for free?
If even one person is swayed by your rant I will be surprised especially when they see that you call yourself BigJohnson.
