First, I think we need to define what you really want.

A straight audio CD (Red Book) will not support video. The preacher's sermon can be on here, along with the ministry spotlight. But you do not have the option of using video. This will however play on people's CD players.

It would be possible to put together a simple data CD which contains both audio and video. This process (should) take longer than a straight audio CD. You would have the option of creating a "Welcome to our church" type webpage that they can view on their computer. On this cd, you could have small/medium sized video clips from various areas of ministry around your church. However, the ratio of free space of data CD to data DVD is quite large. You'd be able to have quite a lot of information on a data CD, but when video is added into the mix, space on your CD will get used rather quickly. If done properly, these disks will play on consumer CD players along with their computer.

You also have the option of doing a DVD. However, this won't play in a regular CD player. The user will need a DVD player. The price of DVD players have dropped quite a bit and I don't see this as a barrier to your project. Just realize that creating a DVD can, and should be, more time consuming compared to the other types of media you could use.

Does this help define what you're trying to do?