One thing that is known is that Patrick Stewart has expressed a desire to see most the principal cast of Star Trek: The Next Generation included in some way before the series’ end, so fans should expect someone from the Enterprise to appear next season like in Season 1.
Unlike Star Trek: Discovery, Star Trek: Picard didn’t end by throwing some big cliffhanger at its audience, so it’s hard to say with certainty where Season 2 is headed.