feat: print error message for failed stream requests

[shuaahvee]

Feature scope

CLI (options, error messages, logging, etc.)

Description

Related slack thread: https://meltano.slack.com/archives/C024T93P0AJ/p1683819057150419

When a stream api call fails, Meltano should return the response body instead of the generic Bad request for path: ... message that is currently returned. This will make the Meltano error message more actionable

[stale[bot]]

This has been marked as stale because it is unassigned, and has not had recent activity. It will be closed after 21 days if no further activity occurs. If this should never go stale, please add the evergreen label, or request that it be added.

[edgarrmondragon]

Still relevant