The profession definitely isn't going anywhere, but it's evolved significantly. Back then, a secretary was just an assistant; now it's more like an administrator with technical skills. Those requirements for databases and CRM - they came about precisely because there's demand for it, and companies are looking for people who can handle it all at once. If you can pick up tools quickly, that's manageable.
The key thing to understand is that what's becoming obsolete isn't the assistant role itself, but its old version - when someone just scheduled meetings and printed documents. These days, companies expect secretaries to optimize processes, manage information, and be the connecting link between departments. It makes the work more interesting, but it requires not just organizational skills but also technical know-how.
It's worth studying if you're drawn to organizational work and aren't intimidated by having to constantly figure out new software. But betting everything on an abstract secretary diploma is risky. Take courses on whatever systems are relevant in your region, show interest in automation, develop your communication skills. Then you'll find work more easily.