Will we ever find out what fury said to Thor to make him unworthy?

At some point, yes.