To be fair, the article doesn't even approach implying that the future of pilots is limited; there is absolutely no pilot vs RPA in this article. It talks about the normalization of the RPA career field and the fact that, it the author's opinion, it is becoming accepted as a stand-alone fully vested career field vs just an "alpha" or similar career field.
Honestly, notwithstanding whatever this article says, the future of the career field is still not as solid as the future of RPA themselves. Even now, ACC is still considering a way to jettison their share of RPA operations to whomever will take it.