I updated my MacBook to Tahoe 26.4 last night and clicking the Today link in any note opens the monthly March note, every time. Running the Open Today's Note directly from Shortcuts also displays the monthly March note.
Will try to troubleshoot later and reply back.