Is the redirect from the payment screen of Web Payment conducted only when a payment succeeds?

No. Payment completion, payment failure, or expiration leads to the redirect from the payment screen of Web Payment, but it cannot be determined which one is the reason at the time of redirect.
The payment status can be determined from "status" of Get payment details.