the biggest difference is that Paypal Express processes the transaction in real time
PayPal Standard does not, the transaction is placed in a queue and is processed on a first come first served basis.
this means that when the customer comes to the checkout success page, it only means that paypal has accepted the payment method, and will process the transaction with the merchant bank to transfer funds at a later time.
with Express checkout, the funds are already transferred.