To be fair, I think most people would be a deadbeat dad if they had a weenie loser like Alexander for a son.
I would have preferred they ditched supergenius Wesley for fairly normal Alexander for doing kid stuff. It would have been much more interesting seeing worf grow as a father and a leader in general as he struggled to overcome his Klingon cultural giga autism and had to figure out that you can't force people to be certain things and to play the hand you are dealt.
Another area where DS9 was better, even if it was "Jake and Nog shove self sealing stem bolts up their ass"
Nog joining Starfleet was a cool character progression, even though it beggars belief that nog could go from being illiterate to passing the exams in the span of like a year when Wesley is a macguffin solving machine and he couldn't get in
Nog was a DEI admission that shockingly worked out well. Wasn't there a Bajoran on Voyager that came out and said the only reason she got into Starfleet was because of Space Affirmative Action?
Honestly, Alexander didn't fully become a weenie loser until DS9.
Yeah, you can't expect a 5 year old to do much BUT complain and play in the mud.
Nog joining Starfleet was brilliant, because they found something that a Ferengi would conceivably excel at (logistics), and basically made him Rain Man at it. If they had made him say... A prodigy medical officer, it wouldn't have been believable or worked as well.
And Alexander is so unlucky that he uses up the Rotarran's bad luck meter so they only have good luck.
The secret of whatever it was that Roddenberry did to her to make her detest Trek and Trekkies so much has been taken to the grave.
Guessing by what we heard about Majel, he probably put it in her but.
Nog joined Starfleet after the disasterous encounter with the Dominion so the rules on admission were probably already relaxed plus he likely got helped by Sisko. Wesley lost to a DEI fish man on the super special early starfleet admission program (That Picard likely sent him to so he got get rid of him faster) and deliberately crashed the shuttle the next time out of spite.
Say what you will about Alexander, he did man up and volunteer to enlist in the KDF and eventually earned the respect from his peers. Although just not in the way he initially expected.
Starfleet did got into the odd position of having more metal than meat after the boneyards been emptied and new ship production ramped up. In addition of skeleton crewing some classes of ships like the Miranda to the absolute minimum. Enlistment standards being lower to accept anyone who can meet basic requirements is a given.