I don't have strong feelings about either Picard or TNG (my Trek shows were TOS and VOY), but I'm very happy about both a return to the future (something that's not a prequel or a reboot, yay!) and, as you say, a main character who isn't a fratboy.