How do I make it so a player can move in the direction they face?

What do you expect to happen versus what really happens?

It seems like you rotate the y axis twice, try removing the second line as your characterbody should rotate around y, not your camera.

Make sure to paste code with proper formatting