Lenny had a long face for weeks after his dog died

In Germany the meaning from long face is at first an expression for disappointment.
Here I mean it is more distress.

Can I use it for both?

The meaning is the same in English. It does not usually mean anything as strong as distress.