Before you condemn your A/C system, let’s try this approach.
You live in the South. The air is hot and humid. The A/C has a natural effect of dehumidifying the air. The evaporator case has a drain for the condensate (condensed water vapor) produced by this effect. The drain allows this water to be expelled outside of the vehicle onto the ground. This is why you can see cars that have just parked developing small puddles of water in the summer when they’ve been running their A/C. This drain can get clogged up. When that happens, the water cannot drain as fast as it should. The evaporator is cold enough to freeze this condensate that cannot drain and creates this mist. If the drain continues to fully clog, the water will eventually find a way out of the evaporator case and onto the carpet inside the car, especially on the passenger side below the glove box area, since that is where the evaporator is usually found. To repair this condition, crawl under the car (sometimes you can see it from the top) and look near the firewall on the passenger side and find the A/C drain. It should look like a rubber elbow that is open on one end and hanging down. Pull it off and inspect it for a clog. If water begins to drain out, that’s a sure sign that you’re making progress. Water doesn’t always drain out, though, especially if it has been a few hours or overnight since the A/C was run.
There are two other possibilities for the mist.
1) The heater core has developed a pinhole leak and engine coolant is causing the mist. However, if this were so, you would notice the distinctive smell of coolant and the mist would feel somewhat oily and lay a film wherever it settled. The carpet would also become moist, but unlike in the previous description, it would feel oily and again smell of coolant.
2) The evaporator core has developed a pinhole leak and refrigerant was escaping causing the mist. This can also have a somewhat sweet-smelling acrid odor, but if the leak was small enough it may not have been noticeable even though there was some fog. This is easy to check by placing manifold gauges on the system and reading the system pressure (I didn’t see a picture that you mentioned you would attach). If the static pressures on both high and low sides (with engine and A/C off) are around 100 psi, the charge is fine and the refrigerant was not leaking. If the pressure is low, or zero, then the refrigerant has been lost, the system needs to be leak tested and repaired prior to evacuation and recharge.
As for the compressor, I think this is coincidental but not related to the mist you described, unless caused by a refrigerant leak. If the compressor seized up and won’t turn when the clutch locks it, one of three things should happen: 1) The clutch will burn from friction producing smoke and a foul odor, or, 2) the belt will slip and cause a loud screeching noise, or, 3) the engine will stall and may even throw off the belt. You should be able to turn the center of the compressor with the engine off and clutch disengaged, although there should be some resistance due to compression action in the closed refrigerant loop. If you take a piece of wire and jumper the load side (contact side, not coil side) of the A/C clutch relay while the engine is running and A/C is turned on, does the compressor engage and turn now?
You described ” When I did a quick visual inspection I saw that the compressor clutch was trying to engage but just wasn’t spinning the compressor.” Can you elaborate on that, please? We can fix this together, if you want to try, but you will need to be my eyes and hands and help me understand the things I cannot see or touch for myself.