I hope someone will reply to my post here about how to check status on this but I believe I've resolved the main issue: I disabled and re-enabled the whole task itself yesterday and it ran this morning as scheduled.
@MajorP93
200gb free space was enough in my production system to cause this. The only thing I didn't try was filling it up until I found the point where it started working.
I confirm that this is the current behaviour, as @pilow reported here https://xcp-ng.org/forum/post/99446
We might change it in the future to make it better, but it won't be trivial to change.