Hi,
I don't think it is the normal behaviour, let me explain.
I've made a Sales Order, this create manufacturing orders. (procurement on real time activate or not)
Then I will just cancel this Sales order. Manufacturing orders previously created by this Sales Order aren't cancel.
The normal behaviour must be : Sales Order cancel => Manufacturing orders attached cancelled