If you put in all the work to build and paint a model rocket, and you don't mind losing it on the first launch, go ahead with those D motors.
Otherwise, you may want to make yourself an adapter and down-size to C and B motors and make sure you get the rocket back.
(Model rockets, by definition, are something where you re-use them with new motors to make repeat flights.)
That Estes Alpha is an excellent starter kit, and performs very well with A and B motors. As you have already learned, it can easily be lost if you use a bigger motor like a C or an 18mm D.
I guess my advice would be to slow down (use smaller motors), enjoy watching the flight, enjoy recovering your rockets, and don't be in such a hurry to use big motors when your launch field is not big enough to recover the rockets. Big motors are fun too, but single-use rockets begin to get expensive!
In dog beers, I've only had one....