Some options are:
Yamaha Clavinova CVP series models. Some are under 10k. All have many instrument sounds in addition to piano and also accompaniment styles and a usable UI for accessing all the sounds and features.
Some Yamaha Clavinova CLP models also have many non-piano sounds. Usually the more expensive ones have more. The CLP-785 looks more or less like an acoustic upright piano and the CLP-775 has the typical "front of a grand" look with the music rest on the top. The 775 is more limited in sounds. If a Yamaha mentions "XG voices" then that means a large palette of 480 instruments sounds, but they are kind of "additional extra" and the quality is what it is. Decent at least.
Often some church organs are included in the digital piano main sound set. Sometimes a "smaller" organ sound may be missing. Kawai has quite a nice palette in some models. An alternative to the "XG" is "GM2" (as in General MIDI level 2). It's also a standardized sound set with a few church (and other) organ sounds and is found in some models from many brands in addition to the main sound set. Sometimes it may exist only for MIDI file playback and other times the sounds are selectable for normal playing too.
Kawai also has the "upright" style CA99 and many other "front of a grand" models in the CA and CN series.
They have many sound samples e.g. on SoundCloud. Here's one playlist including samples of the organ sounds. (Not all found in all models.)https://soundcloud.com/kawai-global/sets/harmonic-imaging-xl-audio-demos
Roland is of course worth looking at. Their LX series has upright looking pianos with powerful sound systems and the HP series models look similar to many of the Yamahas and Kawais. At least some models have over 300 various instrument sounds i.e. the main ones and then the GM2 sound set.
Casio's Celviano GP-510 would fall into the "looks nice in a church" category.
It's a decent digital piano with some additional sounds, but the total number is only 35 and many are piano sounds, so it may not have the ones you are after.
A slighty less known brand is Dexibell, but they've been around for many years already and have a lot of former staff from Roland's former European facilities. Currently their VIVO H10 and H5 models are the more "substantial looking" ones. There's a "somewhat of a grand" and a "somewhat of an upright" design but their designs don't really replicate their acoustic counterparts.
Dexibell is one of the rare digital pianos enabling uploading of additional sounds. (Another one is Nord with their stage focused pianos) Dexibell has a library of their own extra sounds and also so called "sound fonts" can be used and found from the internet. (Not limited to Dexibell's offering.)
They have sounds samples of the built-in sounds under "Demos" and the library of additional sounds on the right side of the product page:https://www.dexibell.com/prodotto/vivo-h10/?lang=en
I think there's just one (albeit good) church organ sound so far, so it's quite limited.
Then of course with any of these models a potential problem is the maximum sound output from the built-in speakers. Is it enough for the space? That's one thing to remember.
And are the organ sounds actually any good. 😀