Is the ending to MGSV supposed to be depressing?

The fact that Venom Snake found out his entire existence was a lie RIGHT before going off to fight and be killed by Solid Snake is pretty sad. The Man Who Sold The World playing during the credits stuck with me for a like a week.