Why is only my macro camera working?

Mayukh Barua, you can indeed go to Apple, but that of course defeats the whole purpose of coming here to iFixit where the whole point is to empower you to be able to repair your own devices.

That being said, yes, at this point it does sound as though the camera module has taken some damage and is no longer functional. Apple has been getting worse and worse with regard to their parts pairing policy so I wanted to do as much homework as possible before recommending you replace the rear camera assembly.

From everything I can find, there are no warnings that if you replace your rear camera it will no longer function or will lose functionality. It does appear, from iFixit's article on the iPhone 14 and Apple's continuing digital repair lockdown, that you'll get a warning if you replace it

iPhone 14 Continues Apple’s Repair Lockdown

With regard to rear camera replacement, here's what it has to say.

Main Cameras

Mostly functional: This component continues to function as intended but with a “genuine parts” warning appearing on screen on every boot.

So it looks like you can replace the cameras and have everything work, but you'll get a pop-up warning when you reboot the phone. This will happen whether or not you use genuine Apple parts. When you replace the screen, that warning only comes up for about two weeks, and from then on you only see it in your settings, where it will show a badge on the settings icon permanently, but I don't know if the same holds true for the camera replacement.

Should you decide you can live with that, here's the iFixit guide showing you how to do that replacement yourself.

iPhone 14 Pro Max Rear-Facing Camera Assembly Replacement - iFixit Repair Guide

Unfortunately, as of this writing the iFixit Store is out of stock on the rear camera assembly, but it seems to be readily available at a number of other sites. I usually start with Amazon, eBay and AliExpress, but there are many other places you can buy it from as well. Here's an example from AliExpress that came up.

Rear Front Camera For iPhone 14 14 Pro Max 14 Mini 14 Plus front camera Replacement Original Test Back clear focus clear - AliExpress

Good luck; I'd love to hear what you decide and how it all turns out!