Looker is able to remove table sorting only for downloads. You'll see the checkbox in the download modal. All other queries will have an ORDER BY clause in SQL.
If you'd like to tell me a little more about your use case, I'd be happy to help you get the results you want. Also, I can pass your suggestion along to the product team.