Main reason for Red Dragon not happening was NASA requesting parachute landing into the ocean instead of the previously planned propulsive landing on land for Dragon 2.

This would mean that SpaceX would need to develop and fund Dragon 2 propulsive landing on their own, with only real mission fully requiring it being Red Dragon.

In the end it was much easier to just drop the whole thing, especially with the much more perspective Starship on the horizon.