HDFC Bank — New Debit Card not received but status is showing active on Net Banking

This is in reference with my new debit card ending with 8646.

Due to security reasons my previous card was blocked on 16th Oct'21 and I had applied for a new card on 18th Oct'21 at the home branch Ahura Centre in Mumbai. On requesting the reference no. from the lady she ended up handing over the customer care no. and said I should reach out to them for updates.
As per the banking guidelines I am supposed to receive the card within 7 working days of applying but since the bank seemed to have surpassed the date, I tried connecting with the customer care executives several times to understand the delay and where my card is but nobody seemed to be of any help. After several tries, I was able to connect with a senior executive Mr. Rahul Deshmukh who helped me revive my net banking and helped me re-apply for card via net banking.
After a few hours of applying for the card online, I received a message from blue dart courier that a dispatch from HDFC Bank has been initiated and will be delivered the next day i.e.28th Oct'21. On receiving the shipment, it turns out I only received the IPIN and no debit card. On trying to check the status of the same online, it turns out that my card is now showing ACTIVE without having received the card or actually activating it.

I immediately connected with customer care again to only be more disappointed with the bank because not 1 person on call helped me, instead kept me on hold for several minutes and disconnected the call. This happened 3 times consecutively.

No message whatsoever has been received from the bank till date with regards to my card and my RM Mr. Rashid Asiruddin Shaikh has been of no help either.