Update and solution:
For anyone coming across this, I did eventually find a solution. It’s simpler than the steps above and can all be wrapped up in CMake.
I have provided a cookbook for switching over from qmake to CMake and also specifics for distributing via the Microsoft Store. This is all in my post Preparing app for Microsoft Store (Qt 6 + CMake) over on the Qt Forum.