That sour smell is probably mildew starting to grow in the carpet and padding. That probably means that the carpet is not dry yet. You have 2 options. One is to call a professional to come out, dry the carpets and treat them with mold and mildew chemicals. The other is to do it yourself.

To do this yourself you'll need a vacuum, a carpet cleaner, a squirrel cage fan for each wet room some chemicals and some time and energy to put into the project. Start by using the carpet cleaner to suck up as much water out of the carpet as possible. Even if the carpet feels dry, the padding may still be wet. If the weather is good, open the curtains and let the sun shine in, and open the windows and keep the air moving. When you can't get any m ore water out of the carpet, pull the carpet up off the tack strip closest to the wetness and put the squirrel cage fan underneath. Position the fan so it is pulling dry air form the room and forcing it under the carpet. Move any heavy furniture as far away as possible, out of the room if the wetness extends close to it. If the fan is set up right, the whole carpet should lift and float and flutter. Leave the fan in place, keeping the room air as fresh and dry as possible until the carpet and the padding are dry. If the weather is rainy, or it's too cold to open a window, try running a dehumidifier, or opening a can of Damp Rid in the room, changing as it is used up.

When the carpet is good and dry, give a few sprays of a mildew neutralizer into the fan and let it be distributed under the carpet that way. Your local carpet professional may have a bottle for sale, or you can use an over the counter preparation. Test the spray on a hidden corner of the carpet first to make sure it won't harm the color or the backing glue.

With the carpet good and dry, the smell should be gone. Tuck the carpet back onto the tack strips. Giving it a firm push toward the wall while holding it flat will help it get back on the tacks and back into position. Go over the carpet several times with your vacuum to pull out any remaining spores that might be trapped in there. Throw the bag away when you are done so you don't spread the spores to the rest of the house.

If this was the first floor of the house, you might also want to look at the floor from underneath, pull back any insulation and make sure that is dry as well. If that is wet, pull it out and replace it or you risk more funky smell and wood rot under the floor!

If the smell remains after the carpet is dry and clean, you may have more than water in the carpet, was there anything washed in from the kitchen? Like milk? Or could there have been a pet stain there lurking in the carpet that was awakened by the moisture? In that case, an enzymatic pet stain cleaner might help. Follow the directions on the bottle. It may be that you still need a professional to get the right combination of equipment and mildew combating chemicals but that is still probably cheaper than replacing all the carpets. Of course, if you hate the carpet, please feel free to replace them and tell everyone a nice lady on the internet said it was the best way to get rid of the smell! It really is the best way to freshen up a musty room!

I have to say I can relate to the problem! When I was in college my apartments toilet broke during the night and sprayed water all over the bathroom all night long. The downstairs neighbors reported a rainstorm in their apartment and the landlord woke me up knocking! The water had flooded out of the bathroom and soaked the carpet for probably 8 feet in all directions out the door! They sent a carpet company to clean it up but all they did was suck it up with a carpet cleaner. The next day the carpet was still damp and the whole apartment started to smell funky! A new company was called and they installed the fans and added the chemicals to stop the mildew and the carpet survived. It took several days for the carpet to get dry though, it was a real adventure trying to walk on it while it was all puffed up!

Good luck with your carpets! Do let me know how it works out!