Sorry for the lengthy reply...
I would love to work in a recording studio, maybe even be a producer.
You can contact local studios and ask to intern. See if you actually like being in that environment for the hours they do, get a feel for what type of bland, horrible stuff actually gets recorded on the regular. Take time to check out the equipment - how it works, how much it costs. See what is really involved in that career.
I was looking into studying audio production and music but all art schools are extremely expensive.
Check out average salaries for the jobs you want, not worth it in my view.
Subscribe to TapeOp (it's free) and read Sound On Sound or other such mags. You will learn a TON if you read carefully. Combine with a few pieces of home recording gear & a few hours of experimentation, you can teach yourself most of the standard techniques.
Even if I wanted to go to a regular college I don't have the grades to get into anything worth it.
Community college. Get your math skills up, then get into electronics. The most successful studio guys also repair, modify, build, and even design studio gear and electronics equipment. If you can do that, you exponentially increase your job prospects (in and out of the studio).
Should I skip schooling altogether?
After ~5 years as a "professional musician", I finally took a "real job" making four or five times more money; couldn't have landed that without my BA or a higher degree. Definitely have a fall-back, you can always play music on your own time (and I still do, for money!). I would actually recommend a trade school, universities are not worth it anymore. I don't know any welders who are out of work...
Are there any plans/ways that you know of that would get me successful through music?
Set yourself up for success...
- be punctual, and easygoing, but hardworking
- bring some extra skills to the table (a driver's license and car, when no else has one, as example)
- learn how to get good sounds on ANY equipment given you
- learn to play songs/artists/genres you hate, expand your musicianship
- meet tons of people, know how to be in the "right place at the right time"
- never talk sh!t about people you deal with
- be available at the drop of a hat
Basically, spend your days learning something that'll make you money. Evenings, nights, and weekends - practice at home, play music with anyone/everyone, go to shows, meet other musicians, record demos for friends, anything to gain experience and get you into the community.
Cheers.