sting in the tail
A disappointing ending to something, such as a story, that is otherwise upbeat and positive. Primarily heard in UK, Australia. The movie began as a sweet, romantic love story, so the tragic ending was an unexpected sting in the tail.