It is set in the PlayerCharacters FollowCamera Post Process settings. Just remove it from the blendables there and it should be all good.
Also just a quick update for the 1.1 release:
I have made the changes shown in my last post and updated the weapons in the demo content. The MainHand/OffHand sockets were rotated for this update.
I also added a quick demo rifle item as an example to show the difference between
what direction a melee weapon Skeletal Mesh should be facing vs something like a rifle when imported.