I believe that baking soda, a steam cleaner, a gentle brush and a lot of patience would take care of the carpet.
The red wine bit... I don't know if anything would work. You know that the sofa appears a standard size. Pottery Barn, Restoration Hardware.. stores like these have slip covers.. some of the ones in Damask look lovely.. and these slip covers look like they would be a perfect fit for your couch.

