what ever happened to this guy?

He let his ego get the best of him. After no-showing several WWF events in 1996, he was fired by Vince McMahon (this was even after Vince gave him a second chance after holding the WWF up for money in 1991). He went to WCW in 1998, fought Hogan in a hideous match, and demanded more money. When Bischoff didn't give him more money, he left. Rumor has it that he was supposed to go to ECW and lose to Tazz in a squash, but that never happened. Aside from a few independent shows, the Warrior is more or less retired from wrestling. Currently, he makes the rounds speaking at colleges. One instance in particular where he said "queering don't make the world go 'round" landed him in hot water. Hope that answers your question.

I wonder if the speeches he makes at colleges are as incoherent as the one's he used to make when he was on WWF.

That was the infamous University of Connecticut speech, which he ended by saying, "queering doesn't make the world work!" You can find the complete speech on Google Video.