An .acsm file must be opened with Adobe Digital Editions
https://wiki.mobileread.com/wiki/ACSM
ADE will open the file and download the actual ebook from Kobos site. On Windows that file should end up in the <My Documents>\My Digital Editions folder.
You can then use the Add Books option in Calibre to add it to your Calibre Library.