Wiring problems of the 2008 Saturn VUE

Both headlight wiring melted. Replaced both side headlights and after 2 years the wire harness melted again the parking pawl gets stuck often. When putting the car in reverse the parking pawl gets stuck. Then it will eventually go into reverse but the car jerks and makes a clunking noise. The light issue I've been dealing with for the last 3 years now. The parking pawl issue has been like this for over a year now.

We were driving i55 south near batesville,ms. At about 7:30pm when the lights started dimming and all the lights on the dash lite up airbags,check engine etc. I immediately pulled off at the batesville,ms. Exit and headed east to the walmart. . The mechanic checked the battery and decoded the SUV and said that the problem was the wiring harnesses which rest on top of the battery. The main brain of the SUV litterly rest on top of the battery. The mechanic shook the harness and the SUV cranked but the lights were dim and we drove it home. I looked at it the next day and the harness is fastened to the top of the battery and it wasn't completely fastened. When the person installed the new battery at autozone it must have not gotten completely fastened. I looked further and noticed that the conduit on all three branches had disintegrated and wires were exposed. There was a wire tie that was clipped below to the battery box and since the conduit disintegrated this causes the wires to pull out from the brain of the SUV. I pulled the wires back up and wrapped these three branches with tape separately. At the bottom where the three went together,I put extra tape and another wire tie to the battery casing. It still jars loose on occasion and I can tell when the light dims at the odometer. I generally raise the hood and push on the first harness until the light stops dimming on the odometer. I won't drive this SUV out of town. I think this was a poor design and gm could have put the brain somewhere else. I retired from gm's delphi packard electric division and used to check first piece sample wiring harnesses. I am thinking they probably used the wrong conduits because they weren't heat resistant,but these wires shouldn't shake loose unless they are unseated or broken. These three connections can completely shut the SUV off even when you are driving if they come loose.

Passenger headlight went out. I attempted to fix it, but a new bulb doesn't resolve the issue. The protective cover over the wiring going to the light is melted and there are noticeable burn marks around the light and light housing.