Change application error to Nexus HandlerError conversion to use non-retryable internal errors

[bergundy]

Needs to be done before the Go SDK goes GA and after the server 1.27.0 release.

Originally posted by @Quinn-With-Two-Ns in #1802 (comment)