UPDATE - I just checked, and I see the card details on Mycards app.
I've set the pin and activated it on PhonePe, will try to make a transaction soon.
Here's the timeline for me:
1. Initially I received the UPI Rupay card pop up on Mycards application. I applied and received the confirmation saying my card will be processed in 10 working days. I applied in May first week (around May 5th).
2. After almost 15 days on 19th May (Friday), I received the notification on MyCards application to apply again. I applied again and received confirmation saying card details will be shared in 24hrs.
3. After 3 working days I received the card details on Mycards application. (24th May)
4. I was able to set the pin using IVR, and add my credit card to UPI application.
5. It has a shared limit with my existing HDFC credit card. I don't think there was any CIBIL enquiry, didn't receive any message as of now.
Thanks everyone for resolving my queries.