Hey, it's actually not as bad as it may seem! I've just finished integrating our sermon podcast into our church's website. You can see it
here. The sermon podcast is running on WordPress, and modifying the theme to fit your site is quite easy.
I'll try to explain it clearly

. Are you running Wordpress on your own server? If you do it this way, it's much easier to modify your theme to fit inside of your website. Visit
http://wordpress.org/ and download the latest version. Follow these instructions to install your wordpress file in about 5 minutes:
http://codex.wordpress.org/Installing_WordPress#Famous_5-Minute_Install. It's pretty easy.
Basically, to customize a theme for your website you need to edit a few files.
First, find the wordpress/wp-content/themes/classic folder. Go ahead and make another copy of this folder and name it according to what you want your theme to be. I'll call it "mynewtheme" for now. Open the mynewtheme folder and open style.css. In the second line, change the name from WordPress Classic to WordPress mynewtheme or whatever you'd like.
Your new theme is now ready to be set up. First, edit the
header.php file to fit the header of your website. Find the code similar to below and insert your header code into where I've shown below:
HTML:
<body bgcolor="#000000">
<div id="rap">
<center>
<!-- All of my header code goes here -->
<!-- My whole navigation layout that you find on my website starts here, and ends with an open table tag ready for the main content to fit inside my website -->
<div id="content-main">
<!-- end header -->
Now that's it for the header.php. Next you want to finish off the header with the
footer.php file. Insert your footer code as shown below.
HTML:
<!-- Begin footer -->
</div></div>
<!-- This is where my table tag is closed off and the rest of my footer is. The end of this code is the end of my webpage -->
</div>
<?php do_action('wp_footer'); ?>
</body>
</html>
After that you've got an integrated wordpress. You can move the sidebar of your wordpress design around by moving the code:
to wherever you'd like. I moved it into my footer.php file inside of another table on the right side of my website. You can find this code in the index.php file originally I believe.
Once you've done that, you can log into your wordpress account. To log in, go to
http://yourwebsite.com/wordpress/wp-login.php. If you renamed the wordpress file to something else, then use that name instead, obviously. After you log in, click on
presentation and then select your theme below. Find the name that you called it. If you find two classic themes, then you didn't rename the theme right in the style.css file.
That's the quickest way I can explain things, so sorry if I'm not very clear.
Hope that helps!
Update: Oh and one more thing, I replaced this code
HTML:
<style type="text/css" media="screen">
@import url( <?php bloginfo('stylesheet_url'); ?> );
</style>
in the header.php file with this:
HTML:
<link href="http://www.mywebsite.com/styles.css" rel="stylesheet" type="text/css"/>
to make the fonts and colors look exactly like what I previously had on my website.