improve error logging for kinesis sdk error

[lmatz]

CREATE
SOURCE stream
       (
   id varchar
)
WITH (
    connector='kinesis',
    stream='******',
    aws.region='*****',
    aws.credentials.role.arn='****',
    aws.credentials.access_key_id = '****',
    aws.credentials.secret_access_key = '*****'
)
     FORMAT PLAIN ENCODE JSON;

[2023-09-28 15:26:16] [XX000] ERROR: ExecuteError: internal error: connector error: failed to construct request
no detailed reasons are found when users try to create a kinesis source.

seems similar to #10993

[lmatz]

https://github.com/risingwavelabs/risingwave/blob/main/src/connector/src/source/kinesis/source/reader.rs#L253