I'd say it depends on your area, if you're willing to ship, your quality and how much you're willing to spend.
In my area, rollers are everywhere, I'm lucky to sell them for $5-$10 even with nice rollers who can easily win first place at the local county Fair (had one of my birds place at state fair too!

kept that one though haha)
Homers I feel like really need to be flown and raced to have value, just aviary homers around me go for $10 but proven racers, babies of racers, and birds in training can go for a lot of money depending on strain and ability (endurance, speed, etc) There are no gold neck Lucerenes or any other varieties of Lucerene near me, except for about 4 hours away into my state. They're gorgeous but rare here, I saw them being sold for $20 a bird at the last show (Dec 2019) I went to in that town

but I guarantee prices will vary by state.
I personally wouldn't say keeping/raining/selling/showing fancy pigeons, at least maybe the way I do it, is very profitable in my area (WA). I have Birmingham Rollers, Oriental Rollers, Portuguese Tumblers, Damascene, Racing Homers, Chinese Owls and a few Ringneck Doves. I find at fair while people love the owls, they're drawn to other people's 'crazy' pigeons, notably the frillack and fantails. Which from my experience with my old 4H group who owns many of these guys, they can be big pains in the butt!
I've never know anyone who made money with pigeons, many people who broke even, the one guy who I believe made some money off of them did white pigeon releases in addition to racing his homers. I've been told you can win some nice prizes from showing but I've only got experience with my county and state fair prizes (which aren't bad, I made I think $100 one year off of entering 20 birds?)
If you're willing to put in the work to train and fly pigeons and buy really good breeding stock to do so I don't see why you couldn't probably pull some profit, but I'd see how your area is, some towns/cities don't have a strong pigeon-keeping presence! It'd suck to spend money to get birds from far away or shipped and then have to pay to ship them to someone who wants them :'( I like local cause it's easy and no shipping
Oh! And thought I should add too, I've got some pigeons who are Not quiet or soft in their coos! Almost as loud as some of our chickens! Generally pigeons can be quiet but just know some decide not to!
