Pipeline compilation error due to build-assets-image: needs 'compile-production-assets'

This MR !34731 (merged) cannot run pipelines due to:

Found errors in your .gitlab-ci.yml: build-assets-image: needs 'compile-production-assets'

From @caalberts in Slack :

It’s a combination of !33713 (merged) and !34756 (merged)