Bungie said last month they "plans to bring at least one new IP to market before 2025". Meaning that in addition to Matter they could release one or more new IPs during 2022-2024:
https://www.bungie.net/en-us/Explore/Detail/News/50109
Another concept art drawing they included in the recruitment video where they shown the artwork you posted with the ships (they didn't mention if it was for Matter or not). What is the source of your first artwork?
Bungie has been way more successful with online games like Destiny than when they did with Halo before, to they point they have been one of the most successful studios in FPS, online MP and GaaS. So Bungie will want to continue with the online stuff.
Sony bought them to have someone super successful something they didn't have before: super successful FPS, online MP and specially GaaS. So Sony will want them to continue with online stuff. In addition to continue creating super sucessful new IPs and to continue Destiny, obviously.
They won't be PS exclusive. When they announced the acquisition
Jim Ryan said Destiny 2 and future Bungie games will continue multipatform including rival consoles. Bungie also specified that
Destiny 2 and future games and expansions wouldn't be PlayStation exclusives.
So maximum they could have exclusivity for game subscriptions, for game demos/betas or who knows if some smalle timed exclusivity for dlcs or games. But in theory all future Bungie games will be available in other consoles. In fact they are working to bring Destiny 2 to Switch via cloud gaming.