There is a great deal more evidence and reason to believe that Hawking is right than there ever has been to support or defend Roddenberry's grandiose and utopian notion that if life similar to ourselves exists those creatures would cooperate with us.
On the contrary, Hawking's position is based on a few flawed assumptions:
1. Intelligent life elsewhere in the universe will have biology compatible with our ecosystem.
2. Earth has resources that can't be found elsewhere.
3. An intelligent species capable of traveling between stars would find it more expedient to enslave/exterminate the rare pocket of intelligent life they come across rather than solve their resource problems technologically.
Say they do come to Earth for resources. What is it they could possibly need that they can't find elsewhere, even in our own solar system? Liquid water? Free oxygen/nitrogen/carbon dioxide? Items 1 and 2 are closely linked: if what they require to survive are the same things we require, then their biology is compatible with our atmosphere and they can't easily find similar conditions elsewhere. Those are some pretty big leaps, in my opinion.
Point 3 is a criticism often leveled at ID4, but can apply to any alien invasion story where the ETs show up to plunder Earth. If you're smart enough to traverse the gulf between stars, why aren't you smart enough to solve your resource problems?
I don't discount that aliens we encounter might be hostile, but I find it difficult to believe they would want something as mundane as our planetary resources. Religious fervor or just plain warmongering/eliminating the competition make a hell of a lot more sense.
It's not even a question of hostility. It's a matter of what life is.
If "xeno life" is biologically incompatible with "Earth life" but capable of using our environment, if it arrives here it will simply push us out. The version of life less capable of expanding and exploiting available niches is by definition not-life. It loses. Intelligence, ethics and choice have nothing more to do with this than they do competing bacterial strains in a petri dish.