Best way to show Data Explorer data on an external website?

Yes, making the request from your server is the correct approach.