The problem is that as far as I'm aware, the Mac doesn't even see it as a live photo in Messages to begin with. It just sees a Jpeg. Open it on your phone, click the share sheet button, save it and then transfer it to the Mac via AirDrop or the Files app