I would have to wait first for this transaction to get confirmed before I can do any other transactions?
You made a small mistake in here. Burning dust entails that the transaction should only contain the dust as the inputs and nothing else. The purpose of certain dust attack is to de-anonymize users by making them spend the dust inputs together with their other inputs and thus resulting in a link between those addresses in the same transaction. By spending the dust with your other UTXOs (inputs), you are doing exactly as they intended. In some cases, the inclusion of that dust input would actually increase your transaction fees disproportionately, making it more expensive to spend the dust.
As long as you take care not to include any of your own inputs in a transaction intended to burn the dust, none of your other transactions will be dependent on that transaction as none of them will be spending the output from the burning transaction.
You can lock specific UTXOs to avoid spending them at all and save the hassle.
See the documentation:
https://bitcoincore.org/en/doc/0.21.0/rpc/wallet/lockunspent/.