From your comment I don't know you have tried this or not, but get some sessions with the best trainer you can. Singing and even speaking with a good voice is incredibly counterintuitive for some people, speaking from experience. You might have everything needed for a great voice expect the skills, or you might be trying for a voice that's far from what works well for you.

You can. That progression is normal. I know this because I am such a case. I wasn’t able to produce a single sound on pitch. Now I can nail some songs (as long as they don‘t go crazy on technique).

Learning to sing is taking control of your voice. You use the same biology that you have been using for speech and other vocal sounds since birth. It all comes built in. Of course it comes more naturally to some people, just like any other activity.

There are some decent videos on YouTube, but take actual vocal lessons if you can. Videos are not a substitute for lessons.

I don‘t like the posted page. The descriptions aren‘t very helpful and neither are most videos on YouTube. I know from experience. For a complete beginner, this is frankly a useless resource.

> How come some people can naturally sing and others produce a horrible screech?

From my own experience many of those "natural" singers simply grew up around music, so it can definitely be learned. Natural talent doesn't really go that far and it's just a small temporary boost that can just as easily be ruined by bad habits later in life. The same is true for other physical abilities.

Some of the best singers got their start on wind instruments. Music is all one big ecosystem of overlapping skills. Unless we're talking legendarily insanely great levels of singing, I don't think any musicians would agree singing is all that special.

In fact, if you isolate the vocals on many hit tracks you might be surprised and disappointed.

Being able to sing on pitch is more music training than voice training. Music can be trained in any voice pretty much. As for vocal range - it is one of the easiest ones to improve! Simple daily drills can get you there. It's the same for simple voice quality things like learning to sing from your chest/diaphragm rather than just a head/nasal voice. As for having an "aesthetic voice", the steps needed is is extremely specific to each individual and each trainer. Both of you will "path" towards something that will be aesthetic for you and also achievable. Musicians e.g do this to adapt themselves to the "beloved" voice of their target industry. For an example, see https://www.google.com/search?q=arijit+singh+voice+transform... - the AI overview is a pretty decent summary with links to original source. Bollywood really likes love songs to be in husky male voices, so he adapted to that. You don't have to do all that of course, but a small % of similar work will get you to "aesthetic" territory.

Listening to lots of vocal music (preferably with very light accompaniment) also helps a looot. We are really good at imitation.