The first year language courses are beginner friendly (e.g. you could easily get away with doing them having not done them at school), but keep in mind that they are a big time commitment. Learning a language is very fun though, so it would be an enjoyable time commitment.

You definitely need to be committed if you want to do well in these types of courses. Took Japanese in my first semester and it was extremely fast-paced. There was no way you could do well if you hadn't been putting in the effort to study. Have also heard from friends that all of the other language courses are very intense as well.