When I read success stories of people(especially from the non-coding background), how they successfully build a project and how they develop front-end, back-end and various things they use in final launch of the product(Js, CND, S3, Route53 and many more), Where can I learn those things and What things are necessary to build something meaningful.
Coding is value delivery, not value creation. Early on its easy to mistake the two, but it's an important distinction to understand. Creating value is done by figuring out what people are struggling with and helping them out with their problems. That's a fundamental key concept of business. Software is just a means to deliver that value. There are other means outside of software too, like creating a helpful blog post or creating a video course etc.
There are also tools like Bubble.is, Kinetise, and Dropsource that would let you build your software without writing code at all. I exclusively use no-code tools. I have a product management background, can write basic frontend code, but find it so much more valuable to spend time building products instead of learning code.
My advice: If you can code, do it. If you can't, take a minute to decide if it's what makes the most sense, or if there are other options to evaluate
Meaningful products don't need a fancy tech stack, just a problem that they solve well. Often the tech only gets added when it's required, when you have some confirmed users to justify the time and money expense.
There are plenty of examples of no-code projects here and on product hunt that people use to solve a problem. (https://www.indiehackers.com/forum/got-over-300-upvotes-on-product-hunt-with-no-code-at-all-49c227b4d5)
I have been a software dev for 8 years and have used all the tech you mentioned. I try to avoid using any of it until it becomes a nesessity.