Warhammer, especially Warhammer 40,000, has gained significant popularity in the mainstream thanks to the success of Space Marines 2. Interest in 40K stories and content soared and new fans joined. This is good news for Games Workshop, which saw licensing revenue increase from $7.2 million to $36.7 million. Henry Cavill and Amazon's approval of the Warhammer 40K project also fueled this success.

relevant
It's time to play Total War: Warhammer 40K.
Creative Assembly has done an incredible job with Total War: Warhammer. Now it's time to take that technology into the 41st millennium.
However, Games Workshop has said it will “continue to be cautious” when it comes to licensing IP for future video games. Part of Space Marine 2's success will depend on how accurate it is in terms of design and lore, and the company probably doesn't want to compromise. So it's little surprise that the Warhammer RPG was quietly canceled late last year.
Thought Pennies' Warhammer RPG has been canceled for late 2024
As reported by MP1st, Thought Pennies, founded in 2020 by Tim Erns, was developing an unannounced Warhammer RPG. This is corroborated by several LinkedIn bios from employees, some of whom also mention that the project is being built using Unreal 5. However, it is unclear whether the Warhammer project has anything to do with 40K, Age of Sigmar, The Old World, or 40K. One of the other properties.
A LinkedIn post from Thought Pennies CCO Daniel Erickson shared the fate of the project and the impact it had on the studio two months ago. “Over the last three years at Thought Pennies we've built something amazing. We've never missed a milestone, the feedback has been great and our partnerships have been strong. We've had nearly 60 rigorously vetted and incredibly independent colleagues from just the two of us and PowerPoint. “He grew as a team and became a passionate professional.”
However, a change in direction at the publisher led to the cancellation of the project and a downsizing of the studio. “However, our publisher has changed strategic direction and our previous projects are now unfunded. Last week we had to downsize our studio,” Erickson said.
It's unclear why the publisher decided to change direction. Especially since Warhammer is such a popular property right now.

Warhammer 40,000: Space Marine 2 sees him again fighting for the Emperor against an army of Tyranid aliens. You must fight to ensure the survival of your empire in the face of extinction.