CSV files are text, you cannot put binary in text!
If you want to place a binary column into a CSV file you will need to encode it as text first. Base64 is a common way to do this - it increases the size by about a third. SQL2025 has a BASE64_ENCODE() function otherwise you will need to use XML: