Why when I rev my engine in drive, it doesn't move?

Honda Accord 2008 sedan LX 2.4L 199k miles. I was accelerating pretty fast and I was reaching 5000 rpm when my car made a huge sound and shaked, I thought I hit something, then my engine made a huge sound so I turned off the car. I turned it back on, it started, when I put it in drive it made a loud sound for half a second, again I pressed the gas and it reved but didnt move. I put it in park and it makes a huge loud continuous sound, so I turned off the car. I put it in neutral to roll it. Then I put it in park and the car still rolls! Please don't tell me it's my transmission because I'm a senior in high school and that would be really bad.

Read more: Why when I rev my engine in drive, it doesn't move?