Make path alias support content moderation in draft and other states

Problem/Motivation

In #2856363: Path alias changes for draft revisions immediately leak into live site → , it was made impossible to submit an alias change for other than the published state as it leaked immediately to the production. However by now the #2336597: Convert path aliases to full featured entities → and #3007669: Add publishing status to path aliases → were implemented so as we have revisioning, we can revert the first patch and make it also work with content moderation correctly, as some sites require to have the capability to set custom aliases without an intervention of an administrator to do it in the URL alias admin interface. (note if you have published to publish you can also do this, but some sites require validations from another party which does not allow such transition.)

Steps to reproduce

1. Has content with content moderation enabled without having publish -> publish transition.
2. Create content with a path alias save to draft and publish it.
3. Edit the same content and try to change the alias and try to save it as draft. (it will fail right now)

Proposed resolution

Allow making the alias into the draft (or other non-published states).

Remaining tasks

- Revert the original patch: #2856363: Path alias changes for draft revisions immediately leak into live site →
- Find out why still does not work and fix it.
- Test

User interface changes

n/a

API changes

n/a

Data model changes

n/a

Release notes snippet

n/a