Does the URL in question follow the structure sitename .com/sitemap.xml ?
^ WordPress sites almost always follow this exact format but with your site name.

It should definitely end in XML, and when you submit it to Google Search console, it should include the full address. including http:// (if its there) to .xml

Test the URL in the address bar in your browser. It should load what looks like a text file (not a regular page)