YES IT WORKS. I've done it twice in recent days. You must have red card as your default payment tho.
When you go to checkout, you should see the redcard 5% discount already taken off under your 'summary' since it's your default payment option. Then click on 'Pay with Target Gift Card' and...