If vacuuming and other methods don’t get the carpet clean you could try a “Spot Bot”
It’s a small carpet cleaning machine that’s used for small areas (mostly for pets) and has a hand attachment that squirts carpet cleaning fluid, has a brush and vacuums the excess water out.
I haven’t used it in my car, but it gets regular usage in my home. They're only about $120