>With a little imagination?
Space is surprisingly good at punishing 'imagination'.
The nose up posture is related to the aerodynamics of reentry. You can't blow through the atmosphere at Mach 25 dead on and have anything but a scorched hulk left afterwards. Those thermal tiles, and that particular reentry profile are required to allow the atmosphere to safely absorb the kinetic energy of a re-entering craft, while keeping the entire thing safe from becoming part of the exotic and exciting chemistry such a process involves and giving some level of control over the down range trajectory through adjusting the lift vector. That lift vector was engineered to be workable in the hypersonic regime, but once you got to subsonic, it was a bit like flying a brick as I recall.
Could a nuclear payload be lifted by the shuttle? Yes. Would the size of the resulting payload make it as effective as a rocket launched warhead? Not so much.
The Space Shuttle was an interesting effort in engineering extremes that only really got off the ground I think due to the unique situation of the time. The Apollo missions were a success, but Vietnam, and a souring disposition toward manned space programs really put the kebash on what the Shuttle was just meant to be one piece of.
I wish I could remember the exact name of NASA's solar system colonization plan back then, but it was truly a glorious thing to read. Politically impossible. Probably economically ruinous given the wars we'd get entangled in over the next 50 years. But a beautiful dream at least.
Interestingly enough, I think it was really a necessary fumble to make in order to realize that reusable rocketry was the more economic launch paradigm to go for.