Verify that Paramount+ is still listed as an active subscription for your Apple ID account. See your subscriptions overview - Apple.
When you go to the Paramount+ Channel in the Apple TV app, then select the Picard show, then select Season 2, episode 1, then that should have the Paramount+ tv channel as default content provider, not requiring you to buy anything, if you have that subscription.
I am located in Canada.
Yes, you mentioned that before. Does your Apple ID account also match for Canada? US residents with US Apple ID might not get access to (all of) their US services when abroad. Only saying where you are located is just half of the puzzle piece. There is Paramount+ in Canada, but that is not exchangeable with Paramount+ in any other country.