the red stuff is rust from the metal pipes used by your well
your screwed bro its going to cost you a RO system and get one with easy to change filters and stock up on filters Ahhhhh sorry for the bad news

P.S.your hot water heater full of this shit too