Well, I for one was against this law (for other reasons besides fish keeping). I didn't like the fish provision either, though I understand and appreciate the intent behind it. But honestly, for most of us, I don't think it will make a huge difference. My understanding is that it makes it illegal by default to import a fish that isn't on the list of approved imports.
The good thing is that the approved list can be added to. (again, this is my understanding; I might not be entirely up to date) The hundreds of commonly kept species will probably start out on the list to begin with. Newer and lesser known species will have to be added, and I'm sure our fish import companies will be on that like crazy once the details of how to do it get sorted out. I'd say those of us who like to keep unusual, wild-caught species are in for some inconvenience and increased prices. The rest of us probably won't notice any difference whatsoever. I strongly doubt that this legislation will end fish keeping.