Incidentally, I had the exact same device. It actually worked pretty good to be honest!

Of course it will not magically be a top tier device. Programs will need some time to load the first time, and then be thrown out of RAM again.
BUT, compared to Windows, it will be a difference between night and day!

I strongly recommend you the silverblue-main-surface-image from universal-blue.org.

Why?

• Because you need the linux-surface-kernel for it to work. Otherwise, most functions, like touchscreen, webcam, adaptive brightness, auto-rotate and more won't work at all.
• You can install the kernel on other distros too, but it might break. I had that already happening. On uBlue, it's baked in and won't break. And if it does, you can just roll back.
• It comes with Gnome by default and provides you a great touchscreen experience
• And you can install Waydroid easily, which gives you access to Android apps.

I don't recommend using another DE than Gnome for that. Especially those "light weight" ones like XFCE are horrible for touchscreens, and if you use a browser, those few hundred MBs RAM less used by them is negotiable.

It would be smooth as butter with a lightweight desktop (probably not KDE). I suggest Linux Mint XFCE edition