Probably not.
The gourds have a much thicker rind or skin. In a squash, it is much thinner. I don't feel that it is durable as a bird house.
When I use to drive North from SW Florida to SC, I went US-301 and Georgia- 4. I passed many a gourd arrangement hanging from a tall metal structure that looked like an antennae. There would be a dozen, three dozen, 50 gourds hanging up.
There I think the species they were trying to attract was the Purple Martin.