That is technically completely wrong, unfortunately. DSL is on OSI Layer 1 (alongside fiber) and is its own medium based on copper. The standard defines the communication between the DSL modem and DSLAM, which usually stand somewhere by the roadside and are connected via fiber optic.
What is meant by fiber-optic internet, as discussed here, is FTTH, meaning the fiber optic cable runs all the way to your basement/utility room. That has nothing to do with DSL anymore and works completely differently technically. The fiber connection is not much different in terms of protocol than your LAN cable at home, just with light instead of copper (very simplified!). The ONT, for example, is "almost" just a dumb Ethernet to fiber converter (+GPON). The access control is managed by the provider via smart hardware, and authentication is often done via PPPoE. This, however, is the only similarity with DSL. DSL requires a lot more technology overall and, above all, electricity to make it all work.
Fiber is also much less susceptible to interference because the provider no longer needs as much hardware. Also, much higher speeds are possible. The DSL standard, for example, already stops at gigabit. In addition, and this might be important for the gaming son, the ping is generally much lower because the packet has to be processed much less and passes through less hardware.
And yes, it initially only goes as far as the basement/utility room and usually continues with WLAN or, at best, LAN. But that’s not too bad at first because with copper over the distance of a normal residential building (max. 55m with Cat6), you can still easily reach 10 Gbit/s.
So, to get to the point, fiber technically does everything better, but if you only watch Netflix and YouTube and occasionally play on your phone, then the small tariff with 150 Mbit/s is enough. But do ask your son; for gaming, a faster connection never hurts. Especially if you often have to download something. That is, according to your description, the only added value I see.