@SHRIHARI-PRAKASAM This has also been broken for me for at least 6 months now. I am seeing the same behaviour as yourself. I have tested with 2 different web pages/notifications and it's the same for both. They just don't redirect you to the tab like they should. I have "Pop-ups and redirects" browser permission enabled.
I'm on Version 109.0.1518.70 (Official build) (64-bit) but like I said, this hasn't worked for a long time.