I’m going to make a case for why I believe Adam was not literally created out of dust, but rather that this was intended to be a statement about human nature.
Then the LORD God formed a man from the dust of the ground and breathed into his nostrils the breath of life, and the man became a living being.
By the sweat of your brow you will eat your food until you return to the ground, since from it you were taken; for dust you are and to dust you will return."
We see in several biblical passages that the grave/underworld is described in dusty terms:
Will it go down to the gates of death? Will we descend together into the dust?"
"What is gained if I am silenced, if I go down to the pit? Will the dust praise you? Will it proclaim your faithfulness?
We also find the underworld in the Epic of Gilgamesh is referred to as the ‘House of Dust’.
We see then that the Israelite’s and other Ancient Near Eastern people associated dust with the afterlife. This is why we return to dust when we die. Dust therefore has connotations of death and mortality.
With this in mind then I do not believe that one is automatically forced to believe that Adam was created out of dust by god. For this could easily merely be a description of human mortality, which is one of the things which makes us what we are. Indeed, it would appear that this may very well be the entire purpose of Genesis 2-3, a tale about human nature, including how we are naturally fallible.