Catch agnostic HTTP error types in prefect and swap the pagination raise

Catch agnostic HTTP error types in prefect and swap the pagination raise #46390