Migrated content becomes Unpublished when Content Moderation Workflow exists for content type

@Sam152 thanks, your solution works great.

I only had to adjust slightly the source in our case (state => status), with our generated migrations from a D6 site:

process:
[...]
  moderation_state:
    plugin: static_map
    source: status
    default_value: draft
    map:
      '0': draft
      '1': published

@Sam152 and @pacproduct, Your solutions worked for me on D7 -> D10, thanks for posting. Never would have made it there without you. :-)

Ditto @Sam152 and @pacproduct - worked a treat! I owe you a beer!