I think there two problems: the upgrade could not handle the way the disk was partitioned (or something else). Everything I tried kept failing until I removed the disk, and completely wiped it. Discussions I found online were not helpful.
The other part is the magic you need to download High Sierra on a newer Macbook. It is not as if you can just go to the Apple store and download it.
That said, I have been using Macbooks for work for the last 10 years or so. They always get upgraded a couple of times during their lifetimes. Usually not a big problem. So I was quite surprised how bad it went.
This has since been replaced by an M1 Air and Office 2021, but the migration was easier this way. Old versions of macOS are listed at this URL, which is how I got a link for the latest 10.15 installer.
If the default/upgrade installation is failing then I'd try creating a bootable installer on USB [1]. If it still fails then try erasing the target drive first to do a clean install (you can do this by running Disk Utility from within the installer).
[1] Instructions here: https://support.apple.com/HT201372