Thanks for the feedback! Fixed the issue, seems like all the enemies and even the player were being treated as floor?? (I didn't even know floor layers was a setting for characterbody2ds)
I see. I was following a 2d side scroller tutorial instead of a top down one and they never mentioned that lol. Well at least now I know for future games!