Eleanor Rigby comes immediately to mind.

Has a different tinge of emotion but Wildfire by Michael Martin Murphey struck me as a very sad song when I was a youngster.

No shortage of sad songs out there. We need them I think.