What changes when you convert MD to CSV
The dashed rule under the header is dropped rather than becoming a row. It is syntax, not data.
A pipe escaped with a backslash is read as a character in the cell. That is the usual reason a hand-written table parses one column too wide in other tools.
Any formatting inside a cell is kept as written. A cell containing **Total** arrives with the asterisks, because they are literally what the file says and stripping them would be a guess about intent.
What carries over from MD to CSV
Markdown records 2 things about a table that CSV has no way to hold.
CSV has no separate idea of a header, so the column names become an ordinary first row and nothing in the file marks them as different from the data.
Anything visual in the Markdown - weight, alignment, colour, column widths - has no counterpart in CSV and is dropped. The values are what survives.
The identifier 007 comes out of the CSV as 007. Reading it as a number would have made it 7, and an id that changes value is worse than one that stays text.
The role "Analyst, data" survives with its comma, in one cell rather than split across two. That is the first thing to check in any converted table, and the usual place a CSV file goes wrong.
The quotes around Jonah "Jo" Pryce are doubled, which is how the delimited formats escape a quote in the CSV.