Good luck. We lost our lance due to the same issue. Got the same automated email response so I went to Reddit, and Mod Tyran said there was an automatic process that would return the item to us “shortly”…that was 45ish days ago but the lance still hasn’t been returned home yet.
Hoping you have better luck!
These should have been returned within 7 days, I'm sorry that they weren't. I've flagged it to be looked into