Mate, the developers care very little about console players. They expect you to give your hard earned money, but they give very little in return, if any. I also doubt the offline patch will ever come to consoles. Look at the PS5 version, it's a mess and performance is terrible. Console players are not a priority to the devs, never have been and never will. It's a pity though, because it's an amazing game. 

Hi! There's been no official confirmation yet about the Hierophant class coming to console, but fingers crossed it’ll be included in an upcoming update. As for the DLC, yes — from what’s been teased, there will be a narrative campaign element. Totally agree with you on the wait — hopefully this time the release will be smoother across all platforms, including Xbox One!