Informative failure notification when PyPI restricts uploads

[suvayu]

Context

Anyway, PyPI is again accepting new uploads and this time I managed to get the publishing step to succeed.

[...] maybe an informative error message would be useful.

Originally posted by @suvayu in https://github.com/spine-tools/spine-conductor/issues/23#issuecomment-2031939190

Example error

• workflow logs

[suvayu]

Other common errors:

• duplicate release

  WARNING  Error during upload. Retry with the --verbose option for more details. 
  ERROR    HTTPError: 400 Bad Request from https://upload.pypi.org/legacy/        
         File already exists. See https://pypi.org/help/#file-name-reuse for    
         more information.

• incorrect package name

  WARNING  Error during upload. Retry with the --verbose option for more details. 
  ERROR    HTTPError: 400 Bad Request from https://test.pypi.org/legacy/          
         Non-user identities cannot create new projects. This was probably      
         caused by successfully using a pending publisher but specifying the    
         project name incorrectly (either in the publisher or in your project's 
         metadata). Please ensure that both match. See:                         
         https://docs.pypi.org/trusted-publishers/troubleshooting/