I'm no Psychiatrist, so feel free to go to one of those, if you feel they would help.
Did you have dreams like that when you were in the borg?
Is it possible for you to rationalise away the elements of your dream?
Repetitively reinforcing a positive image to replace that one, may help.
For example, many of those elements sound like the Arnie movie "Total Recall". Perhaps watching that might help you re-associate those images (that might be a bit too "guy", but might help).
Alternatively, think of it as an image from far into the future, and break down the symbology:
Why do I still have nightmares about the end?
Is it really the end that you are seeing, or maybe the end of a beautiful evening?
Its the same thing about me standing outside
Going out on a moonlit night sounds nice
then the moon gets bloody
Hey, that's not the moon - it's Mars, and it's beautiful!
Then there is fire coming from the sky
Wow - Shooting stars and fireworks.
burning people and babies
Flashback to a TV show, and times gone by, when the world wasn't such a nice place.
But that's history, and now things are better.
And I dont survive
A transformation had to come over the world, to improve man's lot. It wasn't easy, and everyone had to make changed to accomodate, but it was worth it to rebirth a better new world.
I can see myself burning
Baby, you are hot, and your hubby knows it
It looks like the evening isn't over after all...