That’s exactly backwards. If the galaxies are turning red, you are in the future. If you they are turning blue, you are going into the past.

An analogy is that if everyone around you is getting older, similar to red shifted galaxies, it means time is advancing forward. If everyone was getting younger, then you’re going backward in time to the past.

Red is the future.