What chance of long term relationship and marriage working well?

Well, these two signs actually are incompatible, just like fire and water. Leo hates Pisces' hesitation while Pisces hates Leo's arrogance. As a result, their relationship may be full of disputes.

Anyway, zodiac predictions are for your reference. You have to make a decision on your own.