Solution:
You’ll need to create the bucket media-wordpress from your Developer Console or the gsutil tool for example as explained here. Once done, you’ll be able to reference this bucket in WordPress with the format https://storage.googleapis.com/media-wordpress/