Do you know what else helps lift dirt from the surface being cleaned? A brush, a sponge, an absorbent towel, a vacuum, or even just spraying it with water. Using the created carbon dioxide gas is just a mechanical force to push dirt. I mentioned in a different comment that the only kind of useful case for using the bubbles to clean is in places you can't reach, like your drain. https://www.apartmenttherapy.com/vinegar-baking-soda-cleaning-mixture-myth-36880375

Saying you can use the carbon dioxide bubbles to lift dirt is like saying a student can carry all their books between classes with their hands. Sure, it kind of works, but many alternatives will do the job better.