Is it wrong to be a Huntsmen in the Dungeon

Noir is a college student who focused on studying, but was a fan of RWBY, however as he made his way home he died from a heart attack Now he wakes up in a field with a great sword at his side and is shocked on who he looked like. "Shit I just had to be my favorite character" Read as he heads to a city full of gods a dungeon and avoids horny goddesses