Yes, I can confirm that this is normal and expected: the destructive write test clears all sectors, including the data area and the Master Boot Record / partition table too.
After that, you need to create a new partition and format it:
1) please open a file browser dialog of Windows and right click on "This PC".
2) Select Manage
3) in the new window, under Storage section, please select Disk Management
Probably it will immediately show that there is a disk to be initialised: you can select the drive (the USB disk drive in this case) to create a new partition and then format it.
As you used the tests to reveal/stabilize possible issues, the quick format is completely perfect and enough to be used.
After this, a new drive letter will be available to read/write.