And to add to this the cabinet measures 42 inch along the back and 24 inch across the front with a 25 in depth

The sink manufacturers are wrong. You can undermount a 33" x 22" sink with no trouble if you strap, not clip, the sink in place. I've only done this a hundred times.

Oh awesome Thankyou so much

Your cabinets look frameless not framed, right? You can't scoop out the side panels of your corner sink base when they are frameless. You can probably go with a smaller single bowl, but that's it. If they are framed...then Joe is right...you can scoop and strap. :-)

How would I know if it’s framed or frameless?

"You can't scoop out the side panels of your corner sink base when they are frameless."

Sure you can. Just dunk the sink. All kinda room on those corner cabinets. Strap front to back instead of side to side if need be.