This will be a controversial answer for some reasons I think are misplaced. In my opinion Elon Musk seems like he has a potent toxic side to his personality, and he doesn't seem to have a very good grasp of certain things. He also legitimately seems delusional at times.

However in terms of bringing awareness, optimism, and a willingness to actively work on engineering solutions to long-term existential threats to humanity I think his impact on our culture is often understated.