I looked into it and it all seems scary tbh lol. I do some pixelart and ive looked into C# slightly but was wondering if I should try learning java first? Plus the sounds and sfxs scare me the most. Any Tips?
RPGs is a special category. You could look into RPG Maker, which will allow you to create (a certain type of) RPGs quickly. But it's not free, and I'm not sure how many useful skills you learn from that for use in other tools/engines.
Making a (serious, elaborate) RPG in Unity (or Monogame, etc.) is a ton of work. There are assets in the Unity asset store to get you started, but they're also not free (as far as I've seen). But if you want to create a simple, short experience (no elaborate inventory, quest, dialog, etc. systems) that should be doable without tools.
GDScript (Godot) seems very similar to Python, so you cannot go wrong learning that. Godot seems a good engine to start with too.
I would say: pick a tool (Unity, Godot, RPG Maker?), follow some tutorials and see how well it matches your skills and expectations. You can always switch...
Here is some recommendations you can find on itch.io
Easiest game engine with Lua code: https://sparklinlabs.itch.io/craftstudio
Learn music: https://1oogames.itch.io/lovely-composer
Make pixel music: https://terrycavanagh.itch.io/bosca-ceoil
its ok! you dont need to learn proggramming languages it uses visual scipting and has a built in piskel editor , c'mon i entered a game jam with the theme of crafting and i plannned on making a survival rpg game also i am a begginer to! and a 12 yrs old =)
Specifically for game development I'ld recommend Unity Engine, it's easy to use and there's a whole bunch of guides, tutorials and documentation to help you get started. ( https://unity.com/ ) I prefer using the MonoDevelop IDE ( code editor ) while working with Unity, but it's possible to use ( and I think it has become the default editor in recent versions of Unity ) Visual Studio.
Visual Studio is a really great IDE, and free, it's far better than MonoDevelop in my opinion so I'ld recommend it first and foremost, even though I prefer MonoDev myself. :) If developing desktop applications I'ld certainly recommend VS, since it has built-in UI designer tools and include a whole lot more without the need to install a bazillion of add-ons.
Furthermore, I'ld really recommend reading some books about programing in C#- it'll help alot, going through a bunch of online tutorials targetting game development, and specifically development with a certain engine would probably work out allright- but it will likely take a longer time to learn it properly and to stand on your own two feet. To give two examples, click the links below. Pay your local library a visit to see if they have any books on the subject on the shelves! :)
Don’t scare newbies away from text-based code.
There is no need to be afraid, it can be just as simple as visual scripting and you can get work done faster. Typing on a keyboard is a lot more efficient than moving and clicking with a mouse with a bit of practice.
this
this
and this 
i think survival will be ok just without swords or guns =)