Does submitting a cancellation request guarantee that my order will be cancelled?

No. Amazon must be able to stop the order. If it has already progressed too far in fulfillment, the cancellation may fail.