how do I reach 1500 from 500 on rapid?


Improving Your Chess - Resources for Beginners and Beyond...
https://www.chess.com/blog/RussBell/improving-your-chess-resources-for-beginners-and-beyond
https://www.chess.com/blog/RussBell
My best guess is, it will take a couple of years.
If you put in a huge amount of effort and/or are very gifted, maybe you can get there in less than a year.
I haven’t gotten there yet and I am now approaching 2 years and it seems like my chess/rating progress has been somewhat normal. There are people who progress faster, but also people who progress slower.
It all depends on how much effort you put in and how efficiently you manage to use your chess tlme. And also on how gifted you are at chess.
The important thing is to try to enjoy the game and to keep faith that progress will happen, although sometimes it is not easy or fast.
Chess is not easy and to reach 1500 you will have to beat a lot of people who are trying very hard to get to 1500 themselves. Many of these people study, do puzzles, analyse their games etc. so you will have to do that a little better or a little more in order to beat that other person…

Chomp on those hanging pieces like you're playing Pac-Man and you will be 1500 in no time
Woah, am i hallucinating? You aren't @Proud1500USCFPlayer right?

I think training with tactics will help with recognizing mates. As for your concern about defense/attacking, that's definitely a concern in the long run, but I looked at a bit of two of your games and my advice is to focus more on the basics for now. You need to be more solid on things like seeing hanging pieces and basic tactics (forks, pins, skewers etc) before you will be able to think more in terms of coordinated attacks, and being more skilled in those areas is likely to help you gain a lot of points.
I agree with @TheNameOfNames, focus on more incremental progress. It's hard to predict how long 1500 will take. It varies for different people.

Chomp on those hanging pieces like you're playing Pac-Man and you will be 1500 in no time
Woah, am i hallucinating? You aren't @Proud1500USCFPlayer right?
No, just a fan. I could never be as amazing, cool, and funny as the Jerking Troll Legend himself.

Lets say you spend 1 - 2 hours a day studying, playing, and watching chess videos. For the average person it would take at least a year, probably a year and a half to 2 years. I'd say you should aim for a rating of 1000, when you complete that go for 1200, than 1300-1400, etc. It's usually better to stick to smaller goals, than work your way up.
Ill give you a clue. Dont take any advice from anyone rated below 1500 because how would they know.
OP is not even asking for advice actually.
They are asking for an estimate on how long it will take them to reach 1500.

Improving at chess is usually not easy. If you can afford few lessons, I would advise getting a coach. I can teach you how to think during the chess game. After that, your progress is inevitable.
If you can't afford any lessons, here is the excerpt from very good article on how to improve:
Play a lot, analyze your games, and primarily study tactics. Your knowledge of openings, endgame, middlegame, etc. will come from analyzing your games and going over grandmaster games. Only study one of those specific topics if it is clear you are specifically losing because of that topic.
Source: https://www.gautamnarula.com/how-to-get-good-at-chess-fast/
Here is the great YT series from my channel to learn from as well: https://www.youtube.com/playlist?list=PLUrgfsyInqNa1S4i8DsGJwzx1Uhn2AqlT
Good luck either way!

Focus on excellence. Don't focus on perfection. Excellence is striving to become better and better. However, perfection gives you a lot of stress to become that 1500 rating. Take your time and don't be in a stressful state. Strive to get better and better. But still, good luck on your push to 1500. It will be a long journey, but surely you will still make it.

- 15+10 time , analyse the games (don't just go over them 1 minutes to see where are the blunder, study them. It takes atleast the time the game was played. It's fun)
- puzzles: open a word or notebook document, look at puzzle on chess.com, hit Alt+tab⇤ to start writing your answer (Qxf7+ Kh8 Qf8+ Rxf8+ Rxf8#). Only after writing the full line you can play the answer.
understand it takes time. for example if you work on checkmate patterns it's not like you will checkmate the next game but you are "putting wood in the fire", maybe it will come in to play by rejecting a line in which you don't see checkmate (ironically), thus winning the game by not going for a "hopeful" but bad move... or even if it was a good move and it does checkmate - if you don't see it, you are playing upon guessing and that's double edged. It's a good habit to go for lines you see what's gonna happen, not just "feel" or "be tempted" to play stuff... so if in the said position you concretely see another move that completely consolidates a significant material advantage (+10) with no practical chances for the opponent - that can mean checkmate / resignation is only delayed by a few moves ye?...
This is just an example about chess improvement how rejecting (!) a line/move/idea can be the "good affect" of studying how to attack and check mate.
Good luck