Yes there are good parts and bad parts with pretty much everything that happens.
But I'd say its a big time net-positive for both bitcoin and US citizens.
Discussion
I think it is too, especially from the perspective of people who don't spend all day talking about bitcoin. It's a stamp of approval. Most Americans understand stamps of approval, but not digital signatures.
Most people won't read the white paper or even this:
https://blog.lopp.net/how-is-the-21-million-bitcoin-cap-defined-and-enforced/
But they might read this executive order that says bitcoin is capped at 21 million. That's kind of mind blowing.