Exactly, while an interesting exercise, that would be insane!

But built from Lunar/asteroid material ? Sure, you can build 8 by 32 km cylinder from steel with dirt for shielding with that has a standard earth gravity just fine. No exotic materials required:

https://en.wikipedia.org/wiki/O%27Neill_cylinder