it's possible the asexuals got that way from accepting that they were never going to have sex

While many things are possible, I don't think this is quite the way it works with asexuals...

Also smart people are more likely to take ideas seriously, including the idea prevalent in many social circles that having a sex drive is evil.

On the contrary, I think smart people are more likely to recognize that certain "prevalent in many social circles" ideas are bullshit or outright malicious.

Scott Aaronson's problems in this respect did not arise because he is very smart.